Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

sheet level trigger is not working

Hi Folks,

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.

I am not sure, where i did the mistake. Can someone help..

Sub2u

1 Solution

Accepted Solutions
Not applicable

Re: sheet level trigger is not working

Thank You, Its working fine now

8 Replies
vishsaggi
Esteemed Contributor III

Re: sheet level trigger is not working

Can you share a sample app if possible please ??

Not applicable

Re: sheet level trigger is not working

Thanks for the reply.

PFB

Main File - Triggers

Re: sheet level trigger is not working

Hi Subba,

Try below expression as search string in "OnOpen" trigger.

=Max({1}Year)

Not applicable

Re: sheet level trigger is not working

Thanks for the reply Nagaraj.

Can you confirm me one think, can I change the same for Document Level and Sheet Level or Only Document Level?

Re: sheet level trigger is not working

Hi Subba,

That depends on your requirement. If you want to select Max year whenever the document is opened, you can use document level trigger. If you want the trigger to be executed whenever the sheet is activated, you can use sheet level trigger.

manucamon
Valued Contributor III

Re: sheet level trigger is not working

Hi Subba,

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.

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.

Regards!

Not applicable

Re: sheet level trigger is not working

Thank You, Its working fine now

Not applicable

Re: sheet level trigger is not working

Thank You, Its working fine now

Community Browser