topic Re: My fiscal year does not start on the first of the month in QlikView https://community.qlik.com/t5/QlikView/My-fiscal-year-does-not-start-on-the-first-of-the-month/m-p/863667#M1009512 <HTML><HEAD></HEAD><BODY><P>The easiest solution is to create your fiscal calendar in excel for the next 30 years or so and then simply load that excel file into Qlikview. You'll probably waste a lot more time trying to do this in Qlikview.</P></BODY></HTML> Fri, 01 May 2015 16:02:11 GMT Gysbert_Wassenaar 2015-05-01T16:02:11Z My fiscal year does not start on the first of the month https://community.qlik.com/t5/QlikView/My-fiscal-year-does-not-start-on-the-first-of-the-month/m-p/863666#M1009511 <HTML><HEAD></HEAD><BODY><P>I am looking at the year to date function and it lets us start a fiscal year in any month that we want, but my company's fiscal calendar has 364 days a year and every 5 or so years, we have 371 days (because of both leap yeas and the fact that our calendar is 364 days).</P><P>I know that I will need a table of starting dates for the fiscal year.&nbsp; Are there any functions that would let us set the first day as well like we are able to set the first month?</P></BODY></HTML> Fri, 01 May 2015 14:26:35 GMT https://community.qlik.com/t5/QlikView/My-fiscal-year-does-not-start-on-the-first-of-the-month/m-p/863666#M1009511 2015-05-01T14:26:35Z Re: My fiscal year does not start on the first of the month https://community.qlik.com/t5/QlikView/My-fiscal-year-does-not-start-on-the-first-of-the-month/m-p/863667#M1009512 <HTML><HEAD></HEAD><BODY><P>The easiest solution is to create your fiscal calendar in excel for the next 30 years or so and then simply load that excel file into Qlikview. You'll probably waste a lot more time trying to do this in Qlikview.</P></BODY></HTML> Fri, 01 May 2015 16:02:11 GMT https://community.qlik.com/t5/QlikView/My-fiscal-year-does-not-start-on-the-first-of-the-month/m-p/863667#M1009512 Gysbert_Wassenaar 2015-05-01T16:02:11Z Re: My fiscal year does not start on the first of the month https://community.qlik.com/t5/QlikView/My-fiscal-year-does-not-start-on-the-first-of-the-month/m-p/863668#M1009513 <HTML><HEAD></HEAD><BODY><P>Thank you Gysbert, that is what I ended up doing,&nbsp; </P><P>I was able to take advantage of Excel's functionality as to do a good portion of the repetitive work and range fill in. I then exported the values to a CSV and with the help of a load script I have a dynamic master calendar.</P></BODY></HTML> Tue, 14 Jul 2015 19:14:35 GMT https://community.qlik.com/t5/QlikView/My-fiscal-year-does-not-start-on-the-first-of-the-month/m-p/863668#M1009513 2015-07-14T19:14:35Z