topic Apply set analysis in pivot table in QlikView https://community.qlik.com/t5/QlikView/Apply-set-analysis-in-pivot-table/m-p/703883#M253865 <HTML><HEAD></HEAD><BODY><P>Hello Guys ! I need some help!</P><P></P><P>I'm using a pivot table with 2 dimensions : MonthYear and id_code.</P><P>In expression, i have :</P><P></P><P>Count( DISTINCT Aggr (&nbsp;&nbsp; if((( SUM(x) + SUM(y)) = 0), code1), code1, MonthYear))</P><P></P><P>I want to select 1 month in pivot table and show the month selected + 2 previous month. If select in pivot table october, show september and august.</P><P>How to do it?</P><P></P><P>Thanks !</P><P>Morandi</P></BODY></HTML> Fri, 10 Oct 2014 15:14:05 GMT Anonymous 2014-10-10T15:14:05Z Apply set analysis in pivot table https://community.qlik.com/t5/QlikView/Apply-set-analysis-in-pivot-table/m-p/703883#M253865 <HTML><HEAD></HEAD><BODY><P>Hello Guys ! I need some help!</P><P></P><P>I'm using a pivot table with 2 dimensions : MonthYear and id_code.</P><P>In expression, i have :</P><P></P><P>Count( DISTINCT Aggr (&nbsp;&nbsp; if((( SUM(x) + SUM(y)) = 0), code1), code1, MonthYear))</P><P></P><P>I want to select 1 month in pivot table and show the month selected + 2 previous month. If select in pivot table october, show september and august.</P><P>How to do it?</P><P></P><P>Thanks !</P><P>Morandi</P></BODY></HTML> Fri, 10 Oct 2014 15:14:05 GMT https://community.qlik.com/t5/QlikView/Apply-set-analysis-in-pivot-table/m-p/703883#M253865 Anonymous 2014-10-10T15:14:05Z