topic Create a load script that automatically generates the start dates of each month for the financial year in QlikView https://community.qlik.com/t5/QlikView/Create-a-load-script-that-automatically-generates-the-start/m-p/196973#M56820 <HTML><HEAD></HEAD><BODY><P>Maybe this?</P><P style="padding-left:30px;">MyNewDateTable:<BR />LOAD date(addmonths(yearstart(addmonths(today(),-1),0,4),recno()-1)) as MyNewDate<BR />AUTOGENERATE 12;</P></BODY></HTML> Fri, 10 Sep 2010 18:09:48 GMT johnw 2010-09-10T18:09:48Z Create a load script that automatically generates the start dates of each month for the financial year https://community.qlik.com/t5/QlikView/Create-a-load-script-that-automatically-generates-the-start/m-p/196972#M56819 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P>How would I generate automatically in the load script a table that contains all of the start dates for each month of the current financial year, assuming April 2010 to March 2011. The data arrives on a monthly basis (at the end of each month) so, for instance, the data for June would be processed at the start of July. Thus when the data is processed in April (theoretically the start of a new financial year) it would actually be reflecting the last month of the old financial year, so the update of the months should reflect a one month offset to allow for this.</P><P>The table I would like to automatically generate....</P><P>01/04/2010</P><P>01/05/2010</P><P>01/06/2010</P><P>01/07/2010</P><P>01/08/2010</P><P>01/09/2010</P><P>01/10/2010</P><P>01/11/2010</P><P>01/12/2010</P><P>01/01/2011</P><P>01/02/2011</P><P>01/03/2011</P><P>The table I would like generated in May 2011 reflecting the next financial year (April 2011 - March 2012)</P><P>01/04/2011</P><P>01/05/2011</P><P>01/06/2011</P><P>01/07/2011 etc</P><P>It should be generated in May 2011 rather than April 2011 to relfect that fact the data processed at the start of any month reflects the position for the previous month. Any help will be greatly appreciated.</P><P>Many thanks Neil</P><P></P></BODY></HTML> Fri, 10 Sep 2010 14:28:51 GMT https://community.qlik.com/t5/QlikView/Create-a-load-script-that-automatically-generates-the-start/m-p/196972#M56819 2010-09-10T14:28:51Z Create a load script that automatically generates the start dates of each month for the financial year https://community.qlik.com/t5/QlikView/Create-a-load-script-that-automatically-generates-the-start/m-p/196973#M56820 <HTML><HEAD></HEAD><BODY><P>Maybe this?</P><P style="padding-left:30px;">MyNewDateTable:<BR />LOAD date(addmonths(yearstart(addmonths(today(),-1),0,4),recno()-1)) as MyNewDate<BR />AUTOGENERATE 12;</P></BODY></HTML> Fri, 10 Sep 2010 18:09:48 GMT https://community.qlik.com/t5/QlikView/Create-a-load-script-that-automatically-generates-the-start/m-p/196973#M56820 johnw 2010-09-10T18:09:48Z Create a load script that automatically generates the start dates of each month for the financial year https://community.qlik.com/t5/QlikView/Create-a-load-script-that-automatically-generates-the-start/m-p/196974#M56821 <HTML><HEAD></HEAD><BODY><P>John.</P><P>Many thanks as this is spot on. I really appreciate your help.</P><P>Best Regards Neil</P></BODY></HTML> Sat, 11 Sep 2010 09:07:10 GMT https://community.qlik.com/t5/QlikView/Create-a-load-script-that-automatically-generates-the-start/m-p/196974#M56821 2010-09-11T09:07:10Z