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.
