topic Re: on Open in QlikView https://community.qlik.com/t5/QlikView/on-Open/m-p/1432940#M810608 <HTML><HEAD></HEAD><BODY><P>Try:</P><P><STRONG>=Date(AddMonths(today(),-1), 'YYYY.MM')</STRONG></P><P><STRONG><BR /></STRONG></P></BODY></HTML> Wed, 11 Oct 2017 09:35:36 GMT tresB 2017-10-11T09:35:36Z on Open https://community.qlik.com/t5/QlikView/on-Open/m-p/1432935#M810603 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need one input ,</P><P></P><P>When i open application My last month should get selected&nbsp; in YearMotth Field .</P><P></P><P>Can any one tell me how to do this ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/on-Open/m-p/1432935#M810603 subbareddykm 2020-11-25T16:16:04Z Re: on Open https://community.qlik.com/t5/QlikView/on-Open/m-p/1432936#M810604 <HTML><HEAD></HEAD><BODY><P>Use below script on onopen trigger</P><P></P><P>=MaxString(YearMonth)</P></BODY></HTML> Wed, 11 Oct 2017 08:58:03 GMT https://community.qlik.com/t5/QlikView/on-Open/m-p/1432936#M810604 techvarun 2017-10-11T08:58:03Z Re: on Open https://community.qlik.com/t5/QlikView/on-Open/m-p/1432937#M810605 <HTML><HEAD></HEAD><BODY><P><IMG alt="sample.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179217_sample.PNG" style="height: 322px; width: 620px;" /></P></BODY></HTML> Wed, 11 Oct 2017 09:01:16 GMT https://community.qlik.com/t5/QlikView/on-Open/m-p/1432937#M810605 techvarun 2017-10-11T09:01:16Z Re: on Open https://community.qlik.com/t5/QlikView/on-Open/m-p/1432938#M810606 <HTML><HEAD></HEAD><BODY><P>=MaxString(Date#(YearMonth, 'YYYY.MM'))</P></BODY></HTML> Wed, 11 Oct 2017 09:03:12 GMT https://community.qlik.com/t5/QlikView/on-Open/m-p/1432938#M810606 tresB 2017-10-11T09:03:12Z Re: on Open https://community.qlik.com/t5/QlikView/on-Open/m-p/1432939#M810607 <HTML><HEAD></HEAD><BODY><P>It is not selecting last month, let say if current month is 2017.Nov then it show select 2017 Oct, if it is 2018.Jun then it should select 2018 May i.e.2018.05. etc.</P><P></P><P></P><P>I hope you understood</P></BODY></HTML> Wed, 11 Oct 2017 09:32:36 GMT https://community.qlik.com/t5/QlikView/on-Open/m-p/1432939#M810607 subbareddykm 2017-10-11T09:32:36Z Re: on Open https://community.qlik.com/t5/QlikView/on-Open/m-p/1432940#M810608 <HTML><HEAD></HEAD><BODY><P>Try:</P><P><STRONG>=Date(AddMonths(today(),-1), 'YYYY.MM')</STRONG></P><P><STRONG><BR /></STRONG></P></BODY></HTML> Wed, 11 Oct 2017 09:35:36 GMT https://community.qlik.com/t5/QlikView/on-Open/m-p/1432940#M810608 tresB 2017-10-11T09:35:36Z