Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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

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