topic Regarding Quarter comparision in QlikView https://community.qlik.com/t5/QlikView/Regarding-Quarter-comparision/m-p/1310094#M407354 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P>I appreciate your time. </P><P>I am looking for some help with quarter comparison.</P><P>I need to compare current quarter sales vs last year quarter(Same period) . Could you kindly share your ideas!</P><P>Thank you!</P><P>Kiruthiga</P></BODY></HTML> Wed, 12 Apr 2017 17:25:37 GMT 2017-04-12T17:25:37Z Regarding Quarter comparision https://community.qlik.com/t5/QlikView/Regarding-Quarter-comparision/m-p/1310094#M407354 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P>I appreciate your time. </P><P>I am looking for some help with quarter comparison.</P><P>I need to compare current quarter sales vs last year quarter(Same period) . Could you kindly share your ideas!</P><P>Thank you!</P><P>Kiruthiga</P></BODY></HTML> Wed, 12 Apr 2017 17:25:37 GMT https://community.qlik.com/t5/QlikView/Regarding-Quarter-comparision/m-p/1310094#M407354 2017-04-12T17:25:37Z Re: Regarding Quarter comparision https://community.qlik.com/t5/QlikView/Regarding-Quarter-comparision/m-p/1310095#M407355 <HTML><HEAD></HEAD><BODY><P>You can create two variables fro your current &amp; previous Quarter and use them in set analysis.</P><P></P><P>Assuming that your Quarter Field format is [Quarter Year]</P><P></P><P>CurrQuarter&nbsp; = quartername(Max(Date))</P><P>PreQuarter =&nbsp;&nbsp; QuarterName(<SPAN style="font-size: 13.3333px;">quartername(Max(Date))</SPAN>, -1)</P></BODY></HTML> Wed, 12 Apr 2017 17:42:31 GMT https://community.qlik.com/t5/QlikView/Regarding-Quarter-comparision/m-p/1310095#M407355 neelamsaroha157 2017-04-12T17:42:31Z Re: Regarding Quarter comparision https://community.qlik.com/t5/QlikView/Regarding-Quarter-comparision/m-p/1310096#M407356 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sorry </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">PreQuarter =&nbsp;&nbsp; QuarterName(</SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">quartername(Max(Date))</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, -1)&nbsp; will give you last Quarter.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Change it to -- <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">PreQuarter =&nbsp;&nbsp; QuarterName(</SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">quartername(Max(Date))</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, -4)</SPAN><BR /></SPAN></P></BODY></HTML> Wed, 12 Apr 2017 17:46:18 GMT https://community.qlik.com/t5/QlikView/Regarding-Quarter-comparision/m-p/1310096#M407356 neelamsaroha157 2017-04-12T17:46:18Z