topic Re: Dates in QlikView https://community.qlik.com/t5/QlikView/Dates/m-p/915199#M317462 <HTML><HEAD></HEAD><BODY><P>check the master calendar</P><P><A href="https://community.qlik.com/thread/48693">Creating A Master Calendar</A></P></BODY></HTML> Fri, 07 Aug 2015 10:48:39 GMT qlikmsg4u 2015-08-07T10:48:39Z Dates https://community.qlik.com/t5/QlikView/Dates/m-p/915197#M317460 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have following dates :</P><P></P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid rgb(0, 0, 0); width: 101px; height: 0px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH></TR><TR><TD style="padding: 2px;">01-02-2014</TD></TR><TR><TD style="padding: 2px;">28-04-2015</TD></TR></TBODY></TABLE><P></P><P>I want the field with all the dates between above two dates.</P><P></P><P></P><P>Kindly Help.</P></BODY></HTML> Fri, 07 Aug 2015 10:36:13 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/915197#M317460 Mahamed_Qlik 2015-08-07T10:36:13Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/915198#M317461 <HTML><HEAD></HEAD><BODY><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14389442964113337 jive_text_macro" jivemacro_uid="_14389442964113337"> <PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14389443038667405" jivemacro_uid="_14389443038667405" modifiedtitle="true"> <P>Temp:<SPAN style="font-size: 9pt; line-height: 12pt;">Load Date(Date#(Date,'DD-MM-YYYY')) as Date Inline</SPAN></P> <P>[</P> <P>&nbsp; Date</P> <P>&nbsp; 01-02-2014</P> <P>&nbsp; 28-04-2015</P> <P>];</P> <P></P> <P></P> <P>MinMaxDate:</P> <P>Load Min(Date) as MinDate, Max(Date) as MaxDate Resident Temp;</P> <P></P> <P></P> <P>Drop Table Temp;</P> <P></P> <P></P> <P>Let vMinDate = Num(Peek('MinDate',0,'MinMaxDate'));</P> <P>Let vMaxDate = Num(Peek('MaxDate',0,'MinMaxDate'));</P> <P></P> <P></P> <P>Drop Table MinMaxDate;</P> <P></P> <P></P> <P>Final:</P> <P>&nbsp; Load Date($(vMinDate) + IterNo() - 1) as Date</P> <P>AutoGenerate 1</P> <P>While $(vMinDate) + IterNo() - 1 &lt;= $(vMaxDate);</P> </PRE> </PRE></BODY></HTML> Fri, 07 Aug 2015 10:45:11 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/915198#M317461 MK_QSL 2015-08-07T10:45:11Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/915199#M317462 <HTML><HEAD></HEAD><BODY><P>check the master calendar</P><P><A href="https://community.qlik.com/thread/48693">Creating A Master Calendar</A></P></BODY></HTML> Fri, 07 Aug 2015 10:48:39 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/915199#M317462 qlikmsg4u 2015-08-07T10:48:39Z