topic trigger at sheet level in QlikView

trigger at sheet level

rdsuperlike — Fri, 20 Oct 2017 01:34:46 GMT

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

Re: trigger at sheet level

Anil_Babu_Samineni — Fri, 20 Oct 2017 01:39:40 GMT

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?

Re: trigger at sheet level

devarasu07 — Fri, 20 Oct 2017 02:36:41 GMT

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

Re: trigger at sheet level

madhumitha — Fri, 20 Oct 2017 03:46:12 GMT

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