topic Re: Calculate Previous data using the SET Analysis in QlikView https://community.qlik.com/t5/QlikView/Calculate-Previous-data-using-the-SET-Analysis/m-p/781023#M1036906 <HTML><HEAD></HEAD><BODY><P>use $_1</P></BODY></HTML> Tue, 23 Dec 2014 15:01:16 GMT saumyashah90 2014-12-23T15:01:16Z Calculate Previous data using the SET Analysis https://community.qlik.com/t5/QlikView/Calculate-Previous-data-using-the-SET-Analysis/m-p/781022#M1036905 <HTML><HEAD></HEAD><BODY><P><BR />In current scenario requirement is to show current selected data&nbsp; so i used below expression:</P><P><IMG alt="test..JPG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74102_test..JPG" style="height: auto;" /></P><P></P><P></P><P></P><P>But I want another expression which will show the data for last six quarter data exclunding the selected one:</P><P></P><P>For example if I have selected quarter 2014-Q4 then want to show data for&nbsp; quarter "2014-Q3","2014-Q2","2014-Q1","2013-Q4","2013-Q3","2013-Q2".</P><P></P><P>Any one can help me to resolve this issue</P><P></P><P>Also want to optimise the above epression please suggest</P></BODY></HTML> Tue, 23 Dec 2014 14:50:16 GMT https://community.qlik.com/t5/QlikView/Calculate-Previous-data-using-the-SET-Analysis/m-p/781022#M1036905 2014-12-23T14:50:16Z Re: Calculate Previous data using the SET Analysis https://community.qlik.com/t5/QlikView/Calculate-Previous-data-using-the-SET-Analysis/m-p/781023#M1036906 <HTML><HEAD></HEAD><BODY><P>use $_1</P></BODY></HTML> Tue, 23 Dec 2014 15:01:16 GMT https://community.qlik.com/t5/QlikView/Calculate-Previous-data-using-the-SET-Analysis/m-p/781023#M1036906 saumyashah90 2014-12-23T15:01:16Z Re: Calculate Previous data using the SET Analysis https://community.qlik.com/t5/QlikView/Calculate-Previous-data-using-the-SET-Analysis/m-p/781024#M1036907 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi Pankaj,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">See the document below who explain the analysis clearly :</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="4951" data-objecttype="102" href="https://community.qlik.com/docs/DOC-4951" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">Set Analysis: syntaxes, examples</A></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">By Fabrice Aunez,</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I think it will be helpful for your issue !</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">François</P></BODY></HTML> Tue, 23 Dec 2014 16:09:06 GMT https://community.qlik.com/t5/QlikView/Calculate-Previous-data-using-the-SET-Analysis/m-p/781024#M1036907 francoiscave 2014-12-23T16:09:06Z Re: Calculate Previous data using the SET Analysis https://community.qlik.com/t5/QlikView/Calculate-Previous-data-using-the-SET-Analysis/m-p/781025#M1036908 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><SPAN class="Bold" style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN class="Bold" style="font-size: 10pt; line-height: 1.5em;">$1</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> - previous selection.&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">$_1 -- forward selection<BR /></SPAN></P><P></P><P>Regards,</P><P>@Sub2u</P></BODY></HTML> Tue, 23 Dec 2014 17:54:54 GMT https://community.qlik.com/t5/QlikView/Calculate-Previous-data-using-the-SET-Analysis/m-p/781025#M1036908 2014-12-23T17:54:54Z