topic Sheet trigger action OnActivateSheet Select In Field in QlikView https://community.qlik.com/t5/QlikView/Sheet-trigger-action-OnActivateSheet-Select-In-Field/m-p/936265#M323200 <HTML><HEAD></HEAD><BODY><P>How can i set a sheet trigger to select the last 12 months.</P><P></P><P>i have a month year field called MMMYY which contains Sep-15 Oct-15 Aug-15 etc etc</P><P></P><P>I have tried:</P><P></P><P>Field</P><P>MMMYY</P><P></P><P>Search String</P><P>MMMYY - 12</P></BODY></HTML> Thu, 08 Oct 2015 11:32:41 GMT matthewp 2015-10-08T11:32:41Z Sheet trigger action OnActivateSheet Select In Field https://community.qlik.com/t5/QlikView/Sheet-trigger-action-OnActivateSheet-Select-In-Field/m-p/936265#M323200 <HTML><HEAD></HEAD><BODY><P>How can i set a sheet trigger to select the last 12 months.</P><P></P><P>i have a month year field called MMMYY which contains Sep-15 Oct-15 Aug-15 etc etc</P><P></P><P>I have tried:</P><P></P><P>Field</P><P>MMMYY</P><P></P><P>Search String</P><P>MMMYY - 12</P></BODY></HTML> Thu, 08 Oct 2015 11:32:41 GMT https://community.qlik.com/t5/QlikView/Sheet-trigger-action-OnActivateSheet-Select-In-Field/m-p/936265#M323200 matthewp 2015-10-08T11:32:41Z Re: Sheet trigger action OnActivateSheet Select In Field https://community.qlik.com/t5/QlikView/Sheet-trigger-action-OnActivateSheet-Select-In-Field/m-p/936266#M323201 <HTML><HEAD></HEAD><BODY><P>see attachment</P></BODY></HTML> Thu, 08 Oct 2015 11:49:55 GMT https://community.qlik.com/t5/QlikView/Sheet-trigger-action-OnActivateSheet-Select-In-Field/m-p/936266#M323201 maxgro 2015-10-08T11:49:55Z