topic OnActivateSheet trigger help in QlikView https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-help/m-p/974710#M950421 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I currently have one OnActivateSheet trigger set up, Set Variable, which I'm using to control the color and font color of the tabs.&nbsp; I'm trying to add a 2nd OnActivateSheet trigger, to automatically select two values from my "Question" field.&nbsp; The selections are, "Group: Productivity" and "Self: Productivity".&nbsp; I currently have it set as:</P><P></P><P>Action -- Select in Field</P><P>Field -- Question</P><P>Search String -- ='(Group: Productivity|Self: Productivity)'</P><P></P><P>But this doesn't seem to be working.&nbsp; I'm not getting anything selected.&nbsp; If I use just ='Group: Productivity', it works fine, same with Self: Productivity.</P><P></P><P>Also, once I can get this working correctly, should I place a OnLeaveSheet trigger as well?</P><P></P><P>Thanks,</P><P>Tim</P></BODY></HTML> Tue, 08 Dec 2015 19:39:38 GMT 2015-12-08T19:39:38Z OnActivateSheet trigger help https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-help/m-p/974710#M950421 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I currently have one OnActivateSheet trigger set up, Set Variable, which I'm using to control the color and font color of the tabs.&nbsp; I'm trying to add a 2nd OnActivateSheet trigger, to automatically select two values from my "Question" field.&nbsp; The selections are, "Group: Productivity" and "Self: Productivity".&nbsp; I currently have it set as:</P><P></P><P>Action -- Select in Field</P><P>Field -- Question</P><P>Search String -- ='(Group: Productivity|Self: Productivity)'</P><P></P><P>But this doesn't seem to be working.&nbsp; I'm not getting anything selected.&nbsp; If I use just ='Group: Productivity', it works fine, same with Self: Productivity.</P><P></P><P>Also, once I can get this working correctly, should I place a OnLeaveSheet trigger as well?</P><P></P><P>Thanks,</P><P>Tim</P></BODY></HTML> Tue, 08 Dec 2015 19:39:38 GMT https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-help/m-p/974710#M950421 2015-12-08T19:39:38Z Re: OnActivateSheet trigger help https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-help/m-p/974711#M950422 <HTML><HEAD></HEAD><BODY><P>'("Group: Productivity"|"Self: Productivity")'</P><P></P><P>Try that.</P></BODY></HTML> Tue, 08 Dec 2015 20:24:13 GMT https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-help/m-p/974711#M950422 datagrrl 2015-12-08T20:24:13Z Re: OnActivateSheet trigger help https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-help/m-p/974712#M950423 <HTML><HEAD></HEAD><BODY><P>That worked, thank you!&nbsp; </P></BODY></HTML> Tue, 08 Dec 2015 20:39:16 GMT https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-help/m-p/974712#M950423 2015-12-08T20:39:16Z