topic Re: Dynamically define first date for Master calendar in QlikView https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500333#M1137353 <HTML><HEAD></HEAD><BODY><P>Like this?</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13823828147994240" jivemacro_uid="_13823828147994240" modifiedtitle="true"> <P>Temp_Calendar_Range:</P> <P>LOAD</P> <P>&nbsp; Num(Date#(Min(MyDate), 'YYYYMM')) as MinDate</P> <P>Resident [Main Data];</P> <P></P> <P>LET vMinDate = Peek('MinDate', 0, 'Temp_Calendar_Range');</P> <P>DROP Table Temp_Calendar_Range;</P> </PRE></BODY></HTML> Mon, 21 Oct 2013 19:12:12 GMT 2013-10-21T19:12:12Z Dynamically define first date for Master calendar https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500331#M1137351 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How can define dynamically first date for Master calendar?</P><P>Thanks,</P></BODY></HTML> Mon, 21 Oct 2013 18:50:49 GMT https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500331#M1137351 Anonymous 2013-10-21T18:50:49Z Re: Dynamically define first date for Master calendar https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500332#M1137352 <HTML><HEAD></HEAD><BODY><P>What do you mean with first date? </P><P></P><P>First selected? First sorted? Last value? Maximum date possible?</P><P></P><P>Regards, Marcel.</P></BODY></HTML> Mon, 21 Oct 2013 18:58:52 GMT https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500332#M1137352 marcel_olmo 2013-10-21T18:58:52Z Re: Dynamically define first date for Master calendar https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500333#M1137353 <HTML><HEAD></HEAD><BODY><P>Like this?</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13823828147994240" jivemacro_uid="_13823828147994240" modifiedtitle="true"> <P>Temp_Calendar_Range:</P> <P>LOAD</P> <P>&nbsp; Num(Date#(Min(MyDate), 'YYYYMM')) as MinDate</P> <P>Resident [Main Data];</P> <P></P> <P>LET vMinDate = Peek('MinDate', 0, 'Temp_Calendar_Range');</P> <P>DROP Table Temp_Calendar_Range;</P> </PRE></BODY></HTML> Mon, 21 Oct 2013 19:12:12 GMT https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500333#M1137353 2013-10-21T19:12:12Z Re: Re: Dynamically define first date for Master calendar https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500334#M1137354 <HTML><HEAD></HEAD><BODY><P>Please see my attached file.</P><P>I want to make calendar, where I can select any time frame.</P><P></P><P>Thanks,</P></BODY></HTML> Mon, 21 Oct 2013 19:16:57 GMT https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500334#M1137354 Anonymous 2013-10-21T19:16:57Z Re: Dynamically define first date for Master calendar https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500335#M1137355 <HTML><HEAD></HEAD><BODY><P>You mean to say Fiscal year calendar ?</P></BODY></HTML> Tue, 22 Oct 2013 09:49:46 GMT https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500335#M1137355 2013-10-22T09:49:46Z Re: Dynamically define first date for Master calendar https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500336#M1137356 <HTML><HEAD></HEAD><BODY><P>No, regular year</P></BODY></HTML> Tue, 22 Oct 2013 18:13:30 GMT https://community.qlik.com/t5/QlikView/Dynamically-define-first-date-for-Master-calendar/m-p/500336#M1137356 Anonymous 2013-10-22T18:13:30Z