topic Re: Accumulative date in QlikView https://community.qlik.com/t5/QlikView/Accumulative-date/m-p/1372610#M419299 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>if I have understood correctly, like this</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> *,<SPAN style="color: #0000ff;">MonthName</SPAN>(<SPAN style="color: #800000;">DATE_1</SPAN>,11+<SPAN style="color: #800000;">MONTH_1</SPAN>) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">MonthYear</SPAN> <SPAN style="color: #0000ff;">Inline</SPAN> <SPAN style="color: #800000;">[<BR /> DATE_1,YEAR_1, MONTH_1<BR /> 01/01/2016,2016,01<BR /> 02/01/2016,2016,02<BR /> 03/01/2016,2016,03<BR /> 04/01/2016,2016,04<BR /> 05/01/2016,2016,05<BR /> 06/01/2016,2016,06<BR /> 07/01/2016,2016,07<BR /> 08/01/2016,2016,08<BR /> 09/01/2016,2016,09<BR /> 10/01/2016,2016,10<BR /> 11/01/2016,2016,11<BR /> 12/01/2016,2016,12<BR /> 01/01/2017,2017,01<BR /> 02/01/2017,2017,02<BR /> 03/01/2017,2017,03<BR /> 04/01/2017,2017,04<BR /> 05/01/2017,2017,05<BR /> ]</SPAN></SPAN><SPAN style="font-size: 10pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167012_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Thu, 15 Jun 2017 15:37:53 GMT antoniotiman 2017-06-15T15:37:53Z Accumulative date https://community.qlik.com/t5/QlikView/Accumulative-date/m-p/1372609#M419298 <HTML><HEAD></HEAD><BODY><P>i was wondering if you could add an additional field from this code so that it can have an additonal field like these:</P><P></P><P>[Date Field]</P><P>2016</P><P>Jan 2017</P><P>Feb 2017</P><P>Mar 2017</P><P>April 2017</P><P>May 2017</P><P></P><P>LOAD * Inline</P><P>[</P><P>DATE_1,YEAR_1, MONTH_1</P><P>01/01/2016,2016,01</P><P>02/01/2016,2016,02</P><P>03/01/2016,2016,03</P><P>04/01/2016,2016,04</P><P>05/01/2016,2016,05</P><P>06/01/2016,2016,06</P><P>07/01/2016,2016,07</P><P>08/01/2016,2016,08</P><P>09/01/2016,2016,09</P><P>10/01/2016,2016,10</P><P>11/01/2016,2016,11</P><P>12/01/2016,2016,12</P><P>01/01/2017,2017,01</P><P>02/01/2017,2017,02</P><P>03/01/2017,2017,03</P><P>04/01/2017,2017,04</P><P>05/01/2017,2017,05</P><P>];</P><P></P><P>for the additional field, it has a data of 2016, Jan 2017, Feb 2017, and so on</P></BODY></HTML> Thu, 15 Jun 2017 06:06:19 GMT https://community.qlik.com/t5/QlikView/Accumulative-date/m-p/1372609#M419298 qliknexus_kgcru 2017-06-15T06:06:19Z Re: Accumulative date https://community.qlik.com/t5/QlikView/Accumulative-date/m-p/1372610#M419299 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>if I have understood correctly, like this</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> *,<SPAN style="color: #0000ff;">MonthName</SPAN>(<SPAN style="color: #800000;">DATE_1</SPAN>,11+<SPAN style="color: #800000;">MONTH_1</SPAN>) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">MonthYear</SPAN> <SPAN style="color: #0000ff;">Inline</SPAN> <SPAN style="color: #800000;">[<BR /> DATE_1,YEAR_1, MONTH_1<BR /> 01/01/2016,2016,01<BR /> 02/01/2016,2016,02<BR /> 03/01/2016,2016,03<BR /> 04/01/2016,2016,04<BR /> 05/01/2016,2016,05<BR /> 06/01/2016,2016,06<BR /> 07/01/2016,2016,07<BR /> 08/01/2016,2016,08<BR /> 09/01/2016,2016,09<BR /> 10/01/2016,2016,10<BR /> 11/01/2016,2016,11<BR /> 12/01/2016,2016,12<BR /> 01/01/2017,2017,01<BR /> 02/01/2017,2017,02<BR /> 03/01/2017,2017,03<BR /> 04/01/2017,2017,04<BR /> 05/01/2017,2017,05<BR /> ]</SPAN></SPAN><SPAN style="font-size: 10pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167012_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Thu, 15 Jun 2017 15:37:53 GMT https://community.qlik.com/t5/QlikView/Accumulative-date/m-p/1372610#M419299 antoniotiman 2017-06-15T15:37:53Z