OnActivateSheet trigger

[sr_qlikview]

Need help with onactivatesheet trigger. I have never used.

I have datamodel level flag 'IstestFlag'.

when user navigates to SheetA, report should populate data only for 'IstestFlag =1'

[Gysbert_Wassenaar · Accepted solution]

Open the sheet properties window of SheetA and go to the Triggers tab. Click on the Add Action(s) button under OnActivateSheet. Click on Add to add an action to the trigger. Choose Clear All and click OK to add the action. Add another action. Choose the Select in Field now and click on OK. Now fill in IstestFlag as Field and fill in 1 as Search String. Click on OK twice to confirm and exit the properties window. Now if a user activates the sheet all selections will be cleared and then value 1 will be selected in the field IstestFlag. Go to a sheet other than SheetA and make some selections. Now navigate to SheetA. Check the selections. Only value 1 in IstestFlag should be selected.

[sr_qlikview]

Thanks for your time to explain it. I also added onleave trigger to clear the selection. it works fine absolutely on regular desktop version. I enabled the full browser view and it does not work ... triggers does not work for fullbrowser or AJAX ? or am I missing anything?

[jerrysvensson]

OnActivateSheet doesn't work in Ajax.

Some triggers do, you can find information in the Reference manual.