topic Re: Generate dates in QlikView https://community.qlik.com/t5/QlikView/Generate-dates/m-p/439765#M163901 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">This is perfect</SPAN>. <SPAN class="hps">Thank you very much</SPAN>.</SPAN></P><P></P><P><SPAN class="short_text" lang="en">Regards.<BR /></SPAN></P></BODY></HTML> Mon, 22 Oct 2012 18:53:59 GMT spividori 2012-10-22T18:53:59Z Generate dates https://community.qlik.com/t5/QlikView/Generate-dates/m-p/439763#M163899 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">Hello.</SPAN><BR /><SPAN class="hps">Have a</SPAN> <SPAN class="hps">table containing</SPAN> <SPAN class="hps">customer</SPAN> <SPAN class="hps">and the first month</SPAN> <SPAN class="hps">they</SPAN> <SPAN class="hps">made</SPAN> <SPAN class="hps">​​movements</SPAN>. <SPAN class="hps">I need to</SPAN> <SPAN class="hps">generate from</SPAN> <SPAN class="hps">the date</SPAN> <SPAN class="hps">of each client</SPAN> <SPAN class="hps">the following months</SPAN> <SPAN class="hps">until</SPAN> <SPAN class="hps">now</SPAN>.<BR /></SPAN>Example with the client that has number 1:</P><P><SPAN lang="en"><SPAN>Cli&nbsp; F</SPAN></SPAN><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">irst movement</SPAN></SPAN><SPAN lang="en"><SPAN>:</SPAN></SPAN></P><P><SPAN lang="en"><SPAN>1&nbsp;&nbsp;&nbsp; 01.01.2012</SPAN></SPAN></P><P><SPAN lang="en"><SPAN>Generate:</SPAN></SPAN></P><P><SPAN lang="en"><SPAN>1&nbsp;&nbsp;&nbsp;&nbsp; 01.02.2012</SPAN></SPAN></P><P><SPAN lang="en"><SPAN>1&nbsp;&nbsp;&nbsp;&nbsp; 01.03.2012</SPAN></SPAN></P><P><SPAN lang="en"><SPAN>1&nbsp;&nbsp;&nbsp;&nbsp; 01.04.2012</SPAN></SPAN></P><P><SPAN lang="en"><SPAN>1&nbsp;&nbsp;&nbsp;&nbsp; 01.05.2012</SPAN></SPAN></P><P><SPAN lang="en"><SPAN>1&nbsp;&nbsp;&nbsp;&nbsp; 01.06.2012</SPAN></SPAN></P><P><SPAN lang="en"><SPAN>1&nbsp;&nbsp;&nbsp;&nbsp; 01.07.2012</SPAN></SPAN></P><P><SPAN lang="en"><SPAN>1&nbsp;&nbsp;&nbsp;&nbsp; 01.08.2012</SPAN></SPAN></P><P><SPAN lang="en"><SPAN>1&nbsp;&nbsp;&nbsp;&nbsp; 01.09.2012</SPAN></SPAN></P><P><SPAN lang="en"><SPAN>1&nbsp;&nbsp;&nbsp;&nbsp; 01.10.2012</SPAN></SPAN></P><P><BR /><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">and so</SPAN> <SPAN class="hps">with all customers</SPAN><SPAN>.</SPAN></SPAN></P><P></P><P><SPAN class="short_text" lang="en"><SPAN>Regards.<BR /></SPAN></SPAN></P></BODY></HTML> Mon, 22 Oct 2012 14:41:24 GMT https://community.qlik.com/t5/QlikView/Generate-dates/m-p/439763#M163899 spividori 2012-10-22T14:41:24Z Re: Generate dates https://community.qlik.com/t5/QlikView/Generate-dates/m-p/439764#M163900 <HTML><HEAD></HEAD><BODY><P>Check with this,</P><P></P><P>Datos:</P><P>LOAD Cli, Date#(Fec,'DD.MM.YYYY') AS Fec INLINE [</P><P>&nbsp;&nbsp;&nbsp; Cli, Fec</P><P>&nbsp;&nbsp;&nbsp; 1, 01.01.2012</P><P>&nbsp;&nbsp;&nbsp; 2, 01.12.2011</P><P>&nbsp;&nbsp;&nbsp; 3, 01.03.2012</P><P>&nbsp;&nbsp;&nbsp; 4, 01.05.2011</P><P>&nbsp;&nbsp;&nbsp; 5, 01.07.2012</P><P>];</P><P></P><P></P><P>LOAD</P><P>&nbsp; Cli,</P><P>&nbsp; MonthStart(Fec,IterNo()-1) AS CustomerMovementDate</P><P>Resident</P><P>Datos</P><P>While MonthStart(Num(Fec),IterNo()-1)&lt;=MonthStart(today());</P></BODY></HTML> Mon, 22 Oct 2012 15:23:53 GMT https://community.qlik.com/t5/QlikView/Generate-dates/m-p/439764#M163900 CELAMBARASAN 2012-10-22T15:23:53Z Re: Generate dates https://community.qlik.com/t5/QlikView/Generate-dates/m-p/439765#M163901 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">This is perfect</SPAN>. <SPAN class="hps">Thank you very much</SPAN>.</SPAN></P><P></P><P><SPAN class="short_text" lang="en">Regards.<BR /></SPAN></P></BODY></HTML> Mon, 22 Oct 2012 18:53:59 GMT https://community.qlik.com/t5/QlikView/Generate-dates/m-p/439765#M163901 spividori 2012-10-22T18:53:59Z