topic Previous Fiscal YTD in QlikView https://community.qlik.com/t5/QlikView/Previous-Fiscal-YTD/m-p/1108674#M366925 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>I have the following expression set up in my master calendar for the Fiscal YTD which returns either a 0 or 1 in the results. </P><P></P><P>InYearToDate(TempDate, $(varToday),0,4) *-1</P><P></P><P>I can use this field in set analysis and set it to either a 0 or 1, should I want to calculate the current financial year.&nbsp; The 1 <SPAN style="font-size: 10pt; line-height: 1.5em;">currently returns Apr-16 - July-16 data for me</SPAN></P><P></P><P>I admit that I copied this syntax from a previous post and now I want to be able to understand it more as I want to adapt it so I can get the previous Financial YTD</P><P></P><P>I am looking to adapt the syntax so I can get results for Apr15-Jul15 when I set it to 1</P><P></P><P>Can someone kindly help me with this</P><P></P><P>Kind Regards</P><P>Helen</P></BODY></HTML> Thu, 07 Jul 2016 09:20:54 GMT helen_pip 2016-07-07T09:20:54Z Previous Fiscal YTD https://community.qlik.com/t5/QlikView/Previous-Fiscal-YTD/m-p/1108674#M366925 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>I have the following expression set up in my master calendar for the Fiscal YTD which returns either a 0 or 1 in the results. </P><P></P><P>InYearToDate(TempDate, $(varToday),0,4) *-1</P><P></P><P>I can use this field in set analysis and set it to either a 0 or 1, should I want to calculate the current financial year.&nbsp; The 1 <SPAN style="font-size: 10pt; line-height: 1.5em;">currently returns Apr-16 - July-16 data for me</SPAN></P><P></P><P>I admit that I copied this syntax from a previous post and now I want to be able to understand it more as I want to adapt it so I can get the previous Financial YTD</P><P></P><P>I am looking to adapt the syntax so I can get results for Apr15-Jul15 when I set it to 1</P><P></P><P>Can someone kindly help me with this</P><P></P><P>Kind Regards</P><P>Helen</P></BODY></HTML> Thu, 07 Jul 2016 09:20:54 GMT https://community.qlik.com/t5/QlikView/Previous-Fiscal-YTD/m-p/1108674#M366925 helen_pip 2016-07-07T09:20:54Z Re: Previous Fiscal YTD https://community.qlik.com/t5/QlikView/Previous-Fiscal-YTD/m-p/1108675#M366926 <HTML><HEAD></HEAD><BODY><P>I think I have done it!</P><P></P><P>InYearToDate(TempDate, $(varToday),-1,4) *-1 </P><P></P><P>This returns Apr15-Jul15 for me</P><P></P><P>More haste less speed!!!</P></BODY></HTML> Thu, 07 Jul 2016 09:24:55 GMT https://community.qlik.com/t5/QlikView/Previous-Fiscal-YTD/m-p/1108675#M366926 helen_pip 2016-07-07T09:24:55Z