topic How to fix a selection field using Macro in QlikView https://community.qlik.com/t5/QlikView/How-to-fix-a-selection-field-using-Macro/m-p/141619#M505730 <HTML><HEAD></HEAD><BODY><P>How I can to fix a selection field automatically when I open a QVD Sheet?</P><P>It exists some Macro or specific instructions?</P><P>Thanks</P></BODY></HTML> Fri, 17 Apr 2009 03:43:55 GMT 2009-04-17T03:43:55Z How to fix a selection field using Macro https://community.qlik.com/t5/QlikView/How-to-fix-a-selection-field-using-Macro/m-p/141619#M505730 <HTML><HEAD></HEAD><BODY><P>How I can to fix a selection field automatically when I open a QVD Sheet?</P><P>It exists some Macro or specific instructions?</P><P>Thanks</P></BODY></HTML> Fri, 17 Apr 2009 03:43:55 GMT https://community.qlik.com/t5/QlikView/How-to-fix-a-selection-field-using-Macro/m-p/141619#M505730 2009-04-17T03:43:55Z How to fix a selection field using Macro https://community.qlik.com/t5/QlikView/How-to-fix-a-selection-field-using-Macro/m-p/141620#M505731 <HTML><HEAD></HEAD><BODY><P>Any selections in force when the document is saved will still be selected when the document is opened again -- even after reload. This works fine for static selections.</P><P>If you need to make dynamic selections, such as today's date, you'll need to use a macro assigned to the Document OnOpen event. An example is available in the QV Cookbook at:<BR /><A href="http://www.robwunderlich.com/Download.html">http://www.robwunderlich.com/Download.html</A><BR />The specific example is titled "Making initial selections on document open"</P><P>-Rob</P></BODY></HTML> Fri, 17 Apr 2009 08:28:01 GMT https://community.qlik.com/t5/QlikView/How-to-fix-a-selection-field-using-Macro/m-p/141620#M505731 rwunderlich 2009-04-17T08:28:01Z How to fix a selection field using Macro https://community.qlik.com/t5/QlikView/How-to-fix-a-selection-field-using-Macro/m-p/141621#M505732 <HTML><HEAD></HEAD><BODY><P>Rob,</P><P>This problem was solved with your suggestion.</P><P>Thanks a lot for your help</P></BODY></HTML> Sat, 18 Apr 2009 07:28:17 GMT https://community.qlik.com/t5/QlikView/How-to-fix-a-selection-field-using-Macro/m-p/141621#M505732 2009-04-18T07:28:17Z