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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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