topic Re: sheet level trigger is not working in QlikView https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182734#M462405 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply Nagaraj.</P><P></P><P>Can you confirm me one think, can I change the same for Document Level and Sheet Level or Only Document Level?</P></BODY></HTML> Tue, 27 Sep 2016 05:38:21 GMT 2016-09-27T05:38:21Z sheet level trigger is not working https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182730#M462401 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I created a sheet with 2 text objects, when i click a particular object. It will redirected to another sheet. I applied a trigger to show only latest year's data only. By selecting multiple years, by mistake i saved a file with diff year. Now i am trying to view the data, its not showing latest years data.</P><P></P><P>I am not sure, where i did the mistake. Can someone help..</P><P></P><P>Sub2u</P></BODY></HTML> Mon, 26 Sep 2016 17:39:42 GMT https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182730#M462401 2016-09-26T17:39:42Z Re: sheet level trigger is not working https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182731#M462402 <HTML><HEAD></HEAD><BODY><P>Can you share a sample app if possible please ??</P></BODY></HTML> Mon, 26 Sep 2016 18:03:22 GMT https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182731#M462402 vishsaggi 2016-09-26T18:03:22Z Re: sheet level trigger is not working https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182732#M462403 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply.</P><P></P><P>PFB</P><P></P><P>Main File - Triggers</P></BODY></HTML> Tue, 27 Sep 2016 02:54:25 GMT https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182732#M462403 2016-09-27T02:54:25Z Re: sheet level trigger is not working https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182733#M462404 <HTML><HEAD></HEAD><BODY><P>Hi Subba,</P><P></P><P>Try below expression as search string in "OnOpen" trigger.</P><P></P><P><STRONG>=Max({1}Year)</STRONG></P></BODY></HTML> Tue, 27 Sep 2016 03:22:09 GMT https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182733#M462404 tamilarasu 2016-09-27T03:22:09Z Re: sheet level trigger is not working https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182734#M462405 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply Nagaraj.</P><P></P><P>Can you confirm me one think, can I change the same for Document Level and Sheet Level or Only Document Level?</P></BODY></HTML> Tue, 27 Sep 2016 05:38:21 GMT https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182734#M462405 2016-09-27T05:38:21Z Re: sheet level trigger is not working https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182735#M462406 <HTML><HEAD></HEAD><BODY><P>Hi Subba,</P><P></P><P><SPAN style="font-size: 10pt;">That depends on your requirement. I<SPAN style="font-size: 13.3333px;">f you want to select Max year w<SPAN style="font-size: 13.3333px;">henever the document is opened</SPAN>, y</SPAN>ou can use document level trigger. If you want the trigger to be executed whenever the sheet is activated, you can use sheet level trigger.</SPAN></P></BODY></HTML> Tue, 27 Sep 2016 05:57:07 GMT https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182735#M462406 tamilarasu 2016-09-27T05:57:07Z Re: sheet level trigger is not working https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182736#M462407 <HTML><HEAD></HEAD><BODY><P>Hi Subba,</P><P>Use Max({1} Year) on document trigger. When you open a document the trigger is OpenDocument, ActivateSheet don't be executed when open a document.</P><P>ActivateSheet only works when user changes the sheet, and I think that the trigger must be Max(Year) because user will see his selection when changes the sheet.</P><P></P><P>Regards!</P></BODY></HTML> Tue, 27 Sep 2016 06:57:55 GMT https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182736#M462407 Anonymous 2016-09-27T06:57:55Z Re: sheet level trigger is not working https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182737#M462408 <HTML><HEAD></HEAD><BODY><P>Thank You, Its working fine now</P></BODY></HTML> Tue, 27 Sep 2016 09:37:53 GMT https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182737#M462408 2016-09-27T09:37:53Z Re: sheet level trigger is not working https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182738#M462409 <HTML><HEAD></HEAD><BODY><P>Thank You, Its working fine now</P></BODY></HTML> Tue, 27 Sep 2016 09:38:17 GMT https://community.qlik.com/t5/QlikView/sheet-level-trigger-is-not-working/m-p/1182738#M462409 2016-09-27T09:38:17Z