topic Re: Re: Default Today Date on Active Sheet Trigger Not Working in QlikView https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764778#M271827 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this</P><P></P><P>use to to select field value</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14151243459515081" jivemacro_uid="_14151243459515081"> <P>=date(today(),'MM/DD/YYYY')</P> </PRE><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 04 Nov 2014 18:03:48 GMT ashfaq_haseeb 2014-11-04T18:03:48Z Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764775#M271824 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have three actions on Active sheet to get default today's date referring to three different chart objects. Somehow the second Action doesn't work. Wondering do we have any restrictions in count of actions for sheet??'</P></BODY></HTML> Tue, 04 Nov 2014 17:16:36 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764775#M271824 2014-11-04T17:16:36Z Re: Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764776#M271825 <HTML><HEAD></HEAD><BODY><P>Can you upload an file example?</P></BODY></HTML> Tue, 04 Nov 2014 17:20:00 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764776#M271825 ecolomer 2014-11-04T17:20:00Z Re: Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764777#M271826 <HTML><HEAD></HEAD><BODY><P>Attached</P></BODY></HTML> Tue, 04 Nov 2014 17:40:41 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764777#M271826 2014-11-04T17:40:41Z Re: Re: Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764778#M271827 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this</P><P></P><P>use to to select field value</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14151243459515081" jivemacro_uid="_14151243459515081"> <P>=date(today(),'MM/DD/YYYY')</P> </PRE><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 04 Nov 2014 18:03:48 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764778#M271827 ashfaq_haseeb 2014-11-04T18:03:48Z Re: Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764779#M271828 <HTML><HEAD></HEAD><BODY><P>Thanks Ashfaq but still same results.<BR /><BR /></P><P>It's so weird that the second sheet in Actions doesn't work<BR />.</P></BODY></HTML> Tue, 04 Nov 2014 18:34:16 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764779#M271828 2014-11-04T18:34:16Z Re: Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764780#M271829 <HTML><HEAD></HEAD><BODY><P>This is working as expected you need to check your model</P><P>Your second and third selection contradict each other</P><P></P><P>Check your model all your 3 tables are not connected.</P><P>Fix your model.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 04 Nov 2014 18:44:12 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764780#M271829 ashfaq_haseeb 2014-11-04T18:44:12Z Re: Re: Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764781#M271830 <HTML><HEAD></HEAD><BODY><P>Yes they are not related, All three charts are referring to three different tables. Having three different actions should not impact I guess.</P></BODY></HTML> Tue, 04 Nov 2014 19:09:13 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764781#M271830 2014-11-04T19:09:13Z Re: Re: Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764782#M271831 <HTML><HEAD></HEAD><BODY><P>As Qlik is associative model this will not work like this</P><P>Either break the link with the existing table so that you have 3 independent tables if not go with Alternate states.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 04 Nov 2014 19:21:00 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764782#M271831 ashfaq_haseeb 2014-11-04T19:21:00Z Re: Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764783#M271832 <HTML><HEAD></HEAD><BODY><P>Am new to Qlikview, may be your right am unable fix this issue.</P><P>Any details how to fix this??</P></BODY></HTML> Wed, 05 Nov 2014 13:40:26 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764783#M271832 2014-11-05T13:40:26Z Re: Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764784#M271833 <HTML><HEAD></HEAD><BODY><P>Break the link between two table </P><P>Rename any 1 field in joining table.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 05 Nov 2014 20:10:04 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764784#M271833 ashfaq_haseeb 2014-11-05T20:10:04Z Re: Re: Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764785#M271834 <HTML><HEAD></HEAD><BODY><P>I got it. Thanks!!</P></BODY></HTML> Thu, 06 Nov 2014 18:13:54 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764785#M271834 2014-11-06T18:13:54Z Re: Re: Default Today Date on Active Sheet Trigger Not Working https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764786#M271835 <HTML><HEAD></HEAD><BODY><P>Welcome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 06 Nov 2014 18:31:17 GMT https://community.qlik.com/t5/QlikView/Default-Today-Date-on-Active-Sheet-Trigger-Not-Working/m-p/764786#M271835 ashfaq_haseeb 2014-11-06T18:31:17Z