topic Fiscal week in QlikView https://community.qlik.com/t5/QlikView/Fiscal-week/m-p/186965#M50833 <HTML><HEAD></HEAD><BODY><P>Fiscal Year begins on 10/1 and I need to calc Week in my load script based on the fiscal year start date rather than Jan 1. Please advise.</P><P>Thanks!</P></BODY></HTML> Wed, 26 Jan 2011 21:02:14 GMT 2011-01-26T21:02:14Z Fiscal week https://community.qlik.com/t5/QlikView/Fiscal-week/m-p/186965#M50833 <HTML><HEAD></HEAD><BODY><P>Fiscal Year begins on 10/1 and I need to calc Week in my load script based on the fiscal year start date rather than Jan 1. Please advise.</P><P>Thanks!</P></BODY></HTML> Wed, 26 Jan 2011 21:02:14 GMT https://community.qlik.com/t5/QlikView/Fiscal-week/m-p/186965#M50833 2011-01-26T21:02:14Z Fiscal week https://community.qlik.com/t5/QlikView/Fiscal-week/m-p/186966#M50834 <HTML><HEAD></HEAD><BODY><P>Try something like this, this is when your FinYear starts on the 1 April</P><P></P><P>If</P><P>Week(MyDate) &lt; Week( 1st April of the FinYear for MyDate)</P><P></P><P>Then</P><P>&nbsp;&nbsp;&nbsp; 52 +&nbsp; (Week(MyDate) - Week( 1st April of the FinYear for MyDate)) +1</P><P></P><P>Else</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp; IF</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month(MyDate=3)</P><P>&nbsp;&nbsp;&nbsp; Then </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52 +&nbsp; (Week(MyDate) - Week( 1st April of the FinYear for MyDate)) +1</P><P></P><P>&nbsp;&nbsp;&nbsp; Else</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Week(MyDate) - Week( 1st April of the FinYear for MyDate)) +1</P><P></P><P></P><P>Shaun</P></BODY></HTML> Mon, 11 Jul 2011 20:08:17 GMT https://community.qlik.com/t5/QlikView/Fiscal-week/m-p/186966#M50834 shaunsomai 2011-07-11T20:08:17Z