Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
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])
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!