Time period comparison

[CBoardy]

Hi All,

I want to create a column which compares current month against the previous month. The format of months is 01 JAN, 02 FEB, 03 MAR. Is it possible to set it up so that the calculation is dynamic so that when current month changes it changes automatically?

Many Thanks

[vikasmahajan]

Hi ,

You can achieve the same in set analysis using variables:

The syntax for the set analysis in Qlik Sense using a variables is slightly different.

vCurrentMonth   = Date(max([MonthYear]), 'MMM-YY')

vPreviousMonth = Date(addmonths(max([MonthYear]), -1), 'MMM-YY')

Expression

sum({$<MonthYear ={'$(=$(vCurrentMonth))'}>}[Expense Amt])

sum({$<MonthYear = {'$(=$(vPreviousMonth))'}>}[Expense Amt])

[Rams- · Accepted solution]

Hi,

you can use

In table the output will be with expression:

Output with data expression:

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!