topic Previous Fiscal Year in QlikView https://community.qlik.com/t5/QlikView/Previous-Fiscal-Year/m-p/654416#M239116 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am doing some analysis using a fiscal calendar where the years are formatted as 2013/2014, 2014/2015 etc. These have been loaded into the script using the dual function, so each fiscal year also has a numeric value.</P><P></P><P>The problem I'm facing is that I need to create variables for current and previous year. The current year variable (=Fiscal_Year) works fine, and correctly returns the year formatted as yyyy/yyyy in a textbox. However, I'm struggling to get the previous year variable to work in the same way. I've set the variable as =Fiscal_Year-1, this returns the correct numeric value for the fical year, but I can;t get it to return in the text box in the required yyyy/yyyy format. I've tried adding text() around the statement, but to no avail.</P><P></P><P>Any help greatly appreicated!</P></BODY></HTML> Fri, 25 Jul 2014 14:01:53 GMT danielle_v 2014-07-25T14:01:53Z Previous Fiscal Year https://community.qlik.com/t5/QlikView/Previous-Fiscal-Year/m-p/654416#M239116 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am doing some analysis using a fiscal calendar where the years are formatted as 2013/2014, 2014/2015 etc. These have been loaded into the script using the dual function, so each fiscal year also has a numeric value.</P><P></P><P>The problem I'm facing is that I need to create variables for current and previous year. The current year variable (=Fiscal_Year) works fine, and correctly returns the year formatted as yyyy/yyyy in a textbox. However, I'm struggling to get the previous year variable to work in the same way. I've set the variable as =Fiscal_Year-1, this returns the correct numeric value for the fical year, but I can;t get it to return in the text box in the required yyyy/yyyy format. I've tried adding text() around the statement, but to no avail.</P><P></P><P>Any help greatly appreicated!</P></BODY></HTML> Fri, 25 Jul 2014 14:01:53 GMT https://community.qlik.com/t5/QlikView/Previous-Fiscal-Year/m-p/654416#M239116 danielle_v 2014-07-25T14:01:53Z Re: Previous Fiscal Year https://community.qlik.com/t5/QlikView/Previous-Fiscal-Year/m-p/654417#M239117 <HTML><HEAD></HEAD><BODY><P>This is the code we use:</P><P></P><P>vPreviousFiscalYear:</P><P>=num(left(MaxString(Year_Fiscal),4)-1)&amp;'-'&amp;num(right(MaxString(Year_Fiscal),2)-1,'00')</P></BODY></HTML> Fri, 25 Jul 2014 14:07:30 GMT https://community.qlik.com/t5/QlikView/Previous-Fiscal-Year/m-p/654417#M239117 c_gilbert 2014-07-25T14:07:30Z Re: Previous Fiscal Year https://community.qlik.com/t5/QlikView/Previous-Fiscal-Year/m-p/654418#M239118 <HTML><HEAD></HEAD><BODY><P>Many thanks Charlotte, this has done the trick perfectly <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 25 Jul 2014 15:19:14 GMT https://community.qlik.com/t5/QlikView/Previous-Fiscal-Year/m-p/654418#M239118 danielle_v 2014-07-25T15:19:14Z