topic Explanation please in QlikView https://community.qlik.com/t5/QlikView/Explanation-please/m-p/337824#M124598 <HTML><HEAD></HEAD><BODY><P>varMinDate and varMaxDate indicates the min and max dates for the calendar.</P><P></P><P>AutoGenerate &lt;N&gt;, creates the records N times. rowno() will return the row number ie., 10th row will return interger 10.</P><P></P><P>Using these parameters, this code creates a table with date number (integer part of date time) and date starting , from min date incrementing by 1 day, (varMaxDate-varMinDate+1) times. Which will create a temp calander from min date till max date.</P><P></P><P>Hope, I clarified.</P><P></P><P>Regards,</P><P>Kiran Rokkam.</P></BODY></HTML> Mon, 07 May 2012 04:30:49 GMT 2012-05-07T04:30:49Z Explanation please https://community.qlik.com/t5/QlikView/Explanation-please/m-p/337823#M124597 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; $(varMinDate) + rowno() - 1 AS DateNumber,</P><P>&nbsp;&nbsp;&nbsp; date ($(varMinDate) + rowno() - 1) AS TempDate</P><P>AUTOGENERATE</P><P>&nbsp;&nbsp;&nbsp; $(varMaxDate) - $(varMinDate) + 1;</P></BODY></HTML> Sun, 06 May 2012 19:49:44 GMT https://community.qlik.com/t5/QlikView/Explanation-please/m-p/337823#M124597 Anonymous 2012-05-06T19:49:44Z Explanation please https://community.qlik.com/t5/QlikView/Explanation-please/m-p/337824#M124598 <HTML><HEAD></HEAD><BODY><P>varMinDate and varMaxDate indicates the min and max dates for the calendar.</P><P></P><P>AutoGenerate &lt;N&gt;, creates the records N times. rowno() will return the row number ie., 10th row will return interger 10.</P><P></P><P>Using these parameters, this code creates a table with date number (integer part of date time) and date starting , from min date incrementing by 1 day, (varMaxDate-varMinDate+1) times. Which will create a temp calander from min date till max date.</P><P></P><P>Hope, I clarified.</P><P></P><P>Regards,</P><P>Kiran Rokkam.</P></BODY></HTML> Mon, 07 May 2012 04:30:49 GMT https://community.qlik.com/t5/QlikView/Explanation-please/m-p/337824#M124598 2012-05-07T04:30:49Z