topic Re: creating dates in QlikView https://community.qlik.com/t5/QlikView/creating-dates/m-p/686587#M248746 <HTML><HEAD></HEAD><BODY><P><BR />in a variable only...because i am calling a vriable in inputbox</P></BODY></HTML> Tue, 02 Sep 2014 10:23:36 GMT rathnam_qv 2014-09-02T10:23:36Z creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686581#M248740 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P></P><P>i have data for 2012,2013 and 2014.</P><P>and i have two input fields From ,To---&gt;in From field i want to show dates from jul/01/2014 to till date.<BR />how to do that...helpme out!!</P><P></P><P></P><P>Regards,</P><P>Smiley</P></BODY></HTML> Tue, 02 Sep 2014 07:54:51 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686581#M248740 rathnam_qv 2014-09-02T07:54:51Z Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686582#M248741 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Right Qlik of you Calander object --&gt; General tab --&gt; Play with minimum and maximum value.</P><P></P><P>You can define the limit there.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 02 Sep 2014 08:13:26 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686582#M248741 ashfaq_haseeb 2014-09-02T08:13:26Z Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686583#M248742 <HTML><HEAD></HEAD><BODY><P>hi Ashfaq,</P><P>Thanks for ur reply...i tried that option but that is not working fine.</P><P>i have a varible vFrom in this i need to show dates only form 1st july 2014 to till date.</P><P></P><P>Thnaks,</P><P>Smiley.</P></BODY></HTML> Tue, 02 Sep 2014 09:34:37 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686583#M248742 rathnam_qv 2014-09-02T09:34:37Z Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686584#M248743 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you post your sample application.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 02 Sep 2014 09:38:04 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686584#M248743 ashfaq_haseeb 2014-09-02T09:38:04Z Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686585#M248744 <HTML><HEAD></HEAD><BODY><P>sorry i can't post it from my work environment!!</P></BODY></HTML> Tue, 02 Sep 2014 09:46:01 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686585#M248744 rathnam_qv 2014-09-02T09:46:01Z Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686586#M248745 <HTML><HEAD></HEAD><BODY><P>u need after 1st june 2014 dates in varible only or in list box is ok?</P></BODY></HTML> Tue, 02 Sep 2014 09:57:43 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686586#M248745 vinay_hg 2014-09-02T09:57:43Z Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686587#M248746 <HTML><HEAD></HEAD><BODY><P><BR />in a variable only...because i am calling a vriable in inputbox</P></BODY></HTML> Tue, 02 Sep 2014 10:23:36 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686587#M248746 rathnam_qv 2014-09-02T10:23:36Z Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686588#M248747 <HTML><HEAD></HEAD><BODY><P>hi in from input box default set 1st june 2014 and to input box today(). save both in 2 variables.</P><P>then in dimention apply condition if(date&gt;fdate and date&lt;tdate, dimention)</P></BODY></HTML> Tue, 02 Sep 2014 10:31:35 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686588#M248747 vinay_hg 2014-09-02T10:31:35Z Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686589#M248748 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i want to write a dynamic condition...in future August data may come...that time it should change to Aug dates</P></BODY></HTML> Tue, 02 Sep 2014 10:38:20 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686589#M248748 rathnam_qv 2014-09-02T10:38:20Z Re: Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686590#M248749 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have a look at attached application.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 02 Sep 2014 10:48:38 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686590#M248749 ashfaq_haseeb 2014-09-02T10:48:38Z Re: Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686591#M248750 <HTML><HEAD></HEAD><BODY><P>hi then take monthstart(today()); for from</P></BODY></HTML> Tue, 02 Sep 2014 12:01:39 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686591#M248750 vinay_hg 2014-09-02T12:01:39Z Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686592#M248751 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you see my application then go to variable and change the defination of vTest as follows</P><P></P><P><STRONG>=MonthStart(AddMonths(today(),-2))</STRONG></P><P></P><P>It will change your date dynamically like you want.</P><P>i.e in next must you will see data from 1 august instead of 1st july.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 02 Sep 2014 12:17:48 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686592#M248751 ashfaq_haseeb 2014-09-02T12:17:48Z Re: creating dates https://community.qlik.com/t5/QlikView/creating-dates/m-p/686593#M248752 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If there are no more questions, then close this thread.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 04 Sep 2014 07:05:06 GMT https://community.qlik.com/t5/QlikView/creating-dates/m-p/686593#M248752 ashfaq_haseeb 2014-09-04T07:05:06Z