Calculate MOM calculation in chart or table in Qlikview.

If we need to calculate YOY or MOM calculation in Qlikview. We can achieve it by following below steps.

• If we need MOM revenue, Create a variable for previous month as below.

vPriorMonthYear = Date(addmonths(today(), -1), 'MMM-YYYY')

• This will give you month-year value for Previous month.
• In your chart or table expression, please use below formula.

=Sum(num#([Revenue]))- Sum({<[Month Year]={'$(vPriorMonthYear)'},FISCYEAR=,Month=>}Num#([Revenue]))

This will show the MOM value, means current month revenue minus previous month revenue.

thanks,

Shiv Shrotriya