topic Document Defaults in QlikView https://community.qlik.com/t5/QlikView/Document-Defaults/m-p/98093#M765340 <HTML><HEAD></HEAD><BODY><P>I need a sheet to open with the previous year selected. How can make it so every time the document is opened it opens to the previous years data?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Document Defaults https://community.qlik.com/t5/QlikView/Document-Defaults/m-p/98093#M765340 <HTML><HEAD></HEAD><BODY><P>I need a sheet to open with the previous year selected. How can make it so every time the document is opened it opens to the previous years data?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Document-Defaults/m-p/98093#M765340 Anonymous 2020-11-25T16:16:04Z Re: Document Defaults https://community.qlik.com/t5/QlikView/Document-Defaults/m-p/98094#M765341 <HTML><HEAD></HEAD><BODY><P>Go to Sheet Properties -&gt; Add Actions on OnActiveSheet -&gt; Add Action -&gt; Select Action Type: Selection and Action: Select in Field -&gt; Write the Year field name in Field box and write "=Year(AddYears(Today(),-1))" in Search String -&gt; click OK -&gt; click Apply</P></BODY></HTML> Tue, 17 Jul 2018 21:39:52 GMT https://community.qlik.com/t5/QlikView/Document-Defaults/m-p/98094#M765341 kenkuchana 2018-07-17T21:39:52Z