topic Re: Preselect a date on opening a document in QlikView https://community.qlik.com/t5/QlikView/Preselect-a-date-on-opening-a-document/m-p/406091#M488902 <HTML><HEAD></HEAD><BODY><P>try week(addmonths(LastWorkingDate,-9))</P></BODY></HTML> Tue, 04 Dec 2012 17:32:06 GMT Gysbert_Wassenaar 2012-12-04T17:32:06Z Preselect a date on opening a document https://community.qlik.com/t5/QlikView/Preselect-a-date-on-opening-a-document/m-p/406090#M488901 <HTML><HEAD></HEAD><BODY><P>I want the document on opening to select the last data working week. I know about Document Properties/Triggers/Document Event Trigger/OnOpenHasAction. So for example for Oct to Sep as the financial year if the last working date is 16/11/2012 then the working week should be 7.</P><P></P><P>My problem is I have target data till 30/09/2013, so =maxstring(week) would return week 52. I have tried a number of ideas unsucessfully including a version of =Weektoday(). </P><P></P><P>Please can someone point me in the right direction. The script is attached.</P></BODY></HTML> Tue, 04 Dec 2012 17:17:55 GMT https://community.qlik.com/t5/QlikView/Preselect-a-date-on-opening-a-document/m-p/406090#M488901 simongoodman 2012-12-04T17:17:55Z Re: Preselect a date on opening a document https://community.qlik.com/t5/QlikView/Preselect-a-date-on-opening-a-document/m-p/406091#M488902 <HTML><HEAD></HEAD><BODY><P>try week(addmonths(LastWorkingDate,-9))</P></BODY></HTML> Tue, 04 Dec 2012 17:32:06 GMT https://community.qlik.com/t5/QlikView/Preselect-a-date-on-opening-a-document/m-p/406091#M488902 Gysbert_Wassenaar 2012-12-04T17:32:06Z Re: Preselect a date on opening a document https://community.qlik.com/t5/QlikView/Preselect-a-date-on-opening-a-document/m-p/406092#M488903 <HTML><HEAD></HEAD><BODY><P>Thanks I think that did the trick.</P></BODY></HTML> Wed, 05 Dec 2012 10:58:57 GMT https://community.qlik.com/t5/QlikView/Preselect-a-date-on-opening-a-document/m-p/406092#M488903 simongoodman 2012-12-05T10:58:57Z