Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Comparison between any two given months

I have a straight table which currently shows month on month comparison for sales. What I want to show is the comparison between any given months not just consecutive months. Note in my case my months 1-12 are marked as period.

So currently my expressions are :

Exprerssion 1 :Sum({<PERIOD={$(=Max(PERIOD)-1)}>}  $(vCurrencyField))

Expression 2:  Sum({<PERIOD={$(=Max(PERIOD))}>}  $(vCurrencyField))

Expression 3 : Difference between the two above. 

Thanks

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use two variables. Create an input box with two variables vPeriod1 and vPeriod2. Change your expressions to use the variables: Sum({<PERIOD={$(vPeriod1)}>}  $(vCurrencyField))


talk is cheap, supply exceeds demand