topic Re: set analysis in QlikView https://community.qlik.com/t5/QlikView/set-analysis/m-p/853031#M469369 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>Sum({$&lt;MonthID = {“&gt;=$(=Max(MonthID) – 5)&lt;=$(=Max(MonthID))”},Country ={USA,India,China} &gt;} Sales)</P></BODY></HTML> Sat, 11 Jul 2015 06:01:59 GMT robert_mika 2015-07-11T06:01:59Z set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/853028#M469366 <HTML><HEAD></HEAD><BODY><P>hello</P><P>how can i find sales of last six month&nbsp; </P><P>for a given countries=india ,usa,china(in set analysis)</P><P>thanks in advance</P></BODY></HTML> Sat, 11 Jul 2015 04:25:32 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/853028#M469366 2015-07-11T04:25:32Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/853029#M469367 <HTML><HEAD></HEAD><BODY><P>Could you add sample of your data?</P></BODY></HTML> Sat, 11 Jul 2015 05:36:20 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/853029#M469367 robert_mika 2015-07-11T05:36:20Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/853030#M469368 <HTML><HEAD></HEAD><BODY><P>hello robert ,i just need a general expression using set analysis</P></BODY></HTML> Sat, 11 Jul 2015 05:47:50 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/853030#M469368 2015-07-11T05:47:50Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/853031#M469369 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>Sum({$&lt;MonthID = {“&gt;=$(=Max(MonthID) – 5)&lt;=$(=Max(MonthID))”},Country ={USA,India,China} &gt;} Sales)</P></BODY></HTML> Sat, 11 Jul 2015 06:01:59 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/853031#M469369 robert_mika 2015-07-11T06:01:59Z