topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/493971#M184788 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P><SPAN class="hps">In my</SPAN> <SPAN class="hps">example,</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">pivot table</SPAN> <SPAN class="atn hps">"</SPAN>Ult <SPAN class="hps">4m</SPAN>" <SPAN class="hps">I take</SPAN> <SPAN class="hps">the current month and</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">previous 3 months: oct 13, sep 13, ago 13, jul 13. <SPAN class="hps">But now I need</SPAN> <SPAN class="hps">to take</SPAN> <SPAN class="hps">the 3</SPAN> <SPAN class="hps">months</SPAN> <SPAN class="hps">without</SPAN> <SPAN class="hps">current: sep 13, ago 13 jul 13.</SPAN></SPAN></P><P><SPAN class="hps"><SPAN class="hps"></SPAN></SPAN> </P><P><SPAN class="hps"><SPAN class="hps">Regards.</SPAN></SPAN></P><P><SPAN class="hps"></SPAN></P></BODY></HTML> Sat, 19 Oct 2013 11:03:28 GMT spividori 2013-10-19T11:03:28Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/493971#M184788 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P><SPAN class="hps">In my</SPAN> <SPAN class="hps">example,</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">pivot table</SPAN> <SPAN class="atn hps">"</SPAN>Ult <SPAN class="hps">4m</SPAN>" <SPAN class="hps">I take</SPAN> <SPAN class="hps">the current month and</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">previous 3 months: oct 13, sep 13, ago 13, jul 13. <SPAN class="hps">But now I need</SPAN> <SPAN class="hps">to take</SPAN> <SPAN class="hps">the 3</SPAN> <SPAN class="hps">months</SPAN> <SPAN class="hps">without</SPAN> <SPAN class="hps">current: sep 13, ago 13 jul 13.</SPAN></SPAN></P><P><SPAN class="hps"><SPAN class="hps"></SPAN></SPAN> </P><P><SPAN class="hps"><SPAN class="hps">Regards.</SPAN></SPAN></P><P><SPAN class="hps"></SPAN></P></BODY></HTML> Sat, 19 Oct 2013 11:03:28 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/493971#M184788 spividori 2013-10-19T11:03:28Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/493972#M184789 <HTML><HEAD></HEAD><BODY><P><STRONG>Sandro</STRONG></P><P></P><P>Replace your current dimension with this Calculated Dimension :</P><P></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; =if ( not month(AñoMes)&nbsp; = month(today()) , AñoMes )</EM></P><P></P><P>And Tick <EM>Suppress When Value is null.</EM></P><P></P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Sat, 19 Oct 2013 11:23:00 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/493972#M184789 Anonymous 2013-10-19T11:23:00Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/493973#M184790 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P></P><P><SPAN style="font-size: 8pt;">SUM({1&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">AñoMes</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt;$(=Date(AddMonths(Max(AñoMes),-4),'MMM YY'))&nbsp; &lt;$(=Date((Max(AñoMes)),'MMM YY'))"</SPAN><SPAN style="font-size: 8pt;"> }&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Cantidad</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="font-size: 8pt;">Rajni</SPAN></P><P></P></BODY></HTML> Sat, 19 Oct 2013 11:28:13 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/493973#M184790 rajni_batra 2013-10-19T11:28:13Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/493974#M184791 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Thanks</SPAN> R<SPAN class="hps">ajni</SPAN>, <SPAN class="hps">is</SPAN> <SPAN class="hps">what I wanted</SPAN>.</P><P></P><P>Regards.</P></BODY></HTML> Sat, 19 Oct 2013 11:46:56 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/493974#M184791 spividori 2013-10-19T11:46:56Z