0 Replies Latest reply: Sep 4, 2012 7:21 AM by nirmal.raj31 RSS

    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.