Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to write set analysis for previous month selection in current yr

Hi Friends,

    Iam New in Qlikview. =Sum({$<Fyear={$(=max(Fyear)),$(=max(month))}>}sales) This is my Expression To shows Current year month sales.But now i want Previous selection current year month sales and 2nd previous selection current year month sales. For ex: in 2007 sep i click means it shows Sep sales in Current month sales Expression, Aug month sales in previous selection expression, Jul Sales in 2nd previous Selection. Plz Help me.

Regards,

Raj.

0 Replies