Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (1)
Community Browser