topic Re: Prior Quarter with Fiscal Calendar in QlikView https://community.qlik.com/t5/QlikView/Prior-Quarter-with-Fiscal-Calendar/m-p/973888#M960942 <HTML><HEAD></HEAD><BODY><P>Chris,</P><P></P><P>Can you try this.</P><P>May be you need to write a case logic to check if your previous quarter &amp; current quarter are in same year, then consider previous quarter else return null() &amp; in chart dimension properties suppress null.</P><P></P><P>Thanks</P><P>Brad.</P></BODY></HTML> Tue, 27 Oct 2015 16:06:31 GMT 2015-10-27T16:06:31Z Prior Quarter with Fiscal Calendar https://community.qlik.com/t5/QlikView/Prior-Quarter-with-Fiscal-Calendar/m-p/973887#M960941 <HTML><HEAD></HEAD><BODY><P>Is it possible to create a chart showing sales for a Prior Fiscal Quarter?</P><P></P><P>I know how it is done with a standard calendar but the scripting doesn't work when you apply it to a fiscal calendar.&nbsp; I can set up a variable that will calculate the previous quarter as well, however, when I select Quarter 1 it wants to try and display Quarter 0 instead of quarter 4 of the previous fiscal year.</P><P></P><P>Thanks,</P></BODY></HTML> Tue, 27 Oct 2015 14:49:04 GMT https://community.qlik.com/t5/QlikView/Prior-Quarter-with-Fiscal-Calendar/m-p/973887#M960941 Anonymous 2015-10-27T14:49:04Z Re: Prior Quarter with Fiscal Calendar https://community.qlik.com/t5/QlikView/Prior-Quarter-with-Fiscal-Calendar/m-p/973888#M960942 <HTML><HEAD></HEAD><BODY><P>Chris,</P><P></P><P>Can you try this.</P><P>May be you need to write a case logic to check if your previous quarter &amp; current quarter are in same year, then consider previous quarter else return null() &amp; in chart dimension properties suppress null.</P><P></P><P>Thanks</P><P>Brad.</P></BODY></HTML> Tue, 27 Oct 2015 16:06:31 GMT https://community.qlik.com/t5/QlikView/Prior-Quarter-with-Fiscal-Calendar/m-p/973888#M960942 2015-10-27T16:06:31Z