topic Using &quot;Select in Field&quot; to specify a different default value for each Sheet in QlikView https://community.qlik.com/t5/QlikView/Using-quot-Select-in-Field-quot-to-specify-a-different-default/m-p/231376#M83139 <HTML><HEAD></HEAD><BODY><P style="margin:0in 0in 0pt;">The 'OnOpen' event happens when the entire QVW is opened, it does not occur when moving from sheet to sheet.</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">In the properties of the sheet itself, you may add a trigger which can change this variable's value when you change sheets, the event is 'OnActivateSheet'.</P></BODY></HTML> Thu, 22 Jul 2010 21:34:12 GMT 2010-07-22T21:34:12Z Using "Select in Field" to specify a different default value for each Sheet https://community.qlik.com/t5/QlikView/Using-quot-Select-in-Field-quot-to-specify-a-different-default/m-p/231375#M83138 <HTML><HEAD></HEAD><BODY><P>I would like to assign a different default value for a particular field per sheet during initial open of my app.</P><P>Hence, I have created a Document Event Trigger "OnOpen" with the following actions</P><P>Select in Field</P><P>Field : [Include Reload]</P><P>Search String : =<B>if</B>(<B>GetActiveSheetId</B>()='Document\SH01','No',<B>if</B>(<B>GetActiveSheetId</B>()='Document\SH02','Yes'))</P><P>So whenever I open the app and go to sheet 1, the [Include Reload] will always be 'No' and when I go to sheet 2, the value is set to 'Yes'.</P><P>However, the code doesn't work. It always defaults to either Yes or No for both sheets.</P><P>Any ideas ?</P><P></P><P></P></BODY></HTML> Thu, 22 Jul 2010 21:01:22 GMT https://community.qlik.com/t5/QlikView/Using-quot-Select-in-Field-quot-to-specify-a-different-default/m-p/231375#M83138 2010-07-22T21:01:22Z Using "Select in Field" to specify a different default value for each Sheet https://community.qlik.com/t5/QlikView/Using-quot-Select-in-Field-quot-to-specify-a-different-default/m-p/231376#M83139 <HTML><HEAD></HEAD><BODY><P style="margin:0in 0in 0pt;">The 'OnOpen' event happens when the entire QVW is opened, it does not occur when moving from sheet to sheet.</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">In the properties of the sheet itself, you may add a trigger which can change this variable's value when you change sheets, the event is 'OnActivateSheet'.</P></BODY></HTML> Thu, 22 Jul 2010 21:34:12 GMT https://community.qlik.com/t5/QlikView/Using-quot-Select-in-Field-quot-to-specify-a-different-default/m-p/231376#M83139 2010-07-22T21:34:12Z