topic How to write set analysis for previous month selection in current yr in QlikView https://community.qlik.com/t5/QlikView/How-to-write-set-analysis-for-previous-month-selection-in/m-p/383760#M490881 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>&nbsp;&nbsp;&nbsp; Iam New in Qlikview. =Sum({$&lt;Fyear={$(=max(Fyear)),$(=max(month))}&gt;}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.</P><P></P><P></P><P>Regards,</P><P>Raj.</P></BODY></HTML> Tue, 04 Sep 2012 11:21:35 GMT 2012-09-04T11:21:35Z How to write set analysis for previous month selection in current yr https://community.qlik.com/t5/QlikView/How-to-write-set-analysis-for-previous-month-selection-in/m-p/383760#M490881 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>&nbsp;&nbsp;&nbsp; Iam New in Qlikview. =Sum({$&lt;Fyear={$(=max(Fyear)),$(=max(month))}&gt;}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.</P><P></P><P></P><P>Regards,</P><P>Raj.</P></BODY></HTML> Tue, 04 Sep 2012 11:21:35 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-analysis-for-previous-month-selection-in/m-p/383760#M490881 2012-09-04T11:21:35Z