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

Set Analysis on current selection for last year

Good afternoon,

I have two formulas which will do next:

=sum({<SalesDate = {">=$(=MonthStart(AddMonths(Today(),-1)))  <= $(=MonthEnd(AddMonths(Today(),-1)))"}>}Sales)

I use this Set Analysis formula to select only the previous month. In my current selections box, I have selected every month in the current year.

(sum({<Year=, MonthName={'>=$(#=AddMonths(min(MonthName),-12))  <=$(#=AddMonths(max(MonthName),-12))'}, Month = ,Day = >}           Sales))   

Then I have this formule which will give me, based on the current selections, the sales based on last year.

I would like to combine these formulas. When I select the months January and February, I would like to see the sales based on last years February.

Is there a simple solution for this problem?

Regards Timo

0 Replies