Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

trigger at sheet level

Hi,

when my sheet 1 opens, I want emp = a selected.

when i click on sheet 2, I want empx = active be selected.

Basically, I want to clear the selection as soon as they leave the sheet and whne they come back it should be there.

I tried onactivate sheet at sheet property level in each tab and then also kept clear field for that filter. It clears but doesnt activate when i click on the respective sheets.

Any help is appreciated.

Thanks

3 Replies
Highlighted

If you clear from sheet 1 to sheet 2. And again, You are back to sheet 1 that means we are activate the Emp a and after the sheet 2 should be clear?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Master II
Master II

Hi,

Use a trigger OnLeaveSheet, right click on the background of the sheet Properties > Triggers > OnLeaveSheet > Add Actions Selection > Clear All

If you need to select or deselect when activating a new sheet, use instead OnActivateSheet following the same steps

Highlighted
Creator
Creator

Hello Ria,

Basically you have to store the selection of Sheet1 into a variable while leaving the sheet1. When you are activating the Sheet1 again, you have to reassign the variable value in to 'emp'

On leave Sheet1

1) Get selected value of field in EMP - store it into Variable.

2) Clear all

On Activate Sheet 1

1) Select in Field Variable value

Hope This helps

Thanks