Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
well i am working on a dashboard i have in several sheets Ex:
Sheet 1 , Sheet2 , Sheet3
when i select on ID in sheet1 this will filter also sheet 2 and sheet3 by this ID (this is not a problem to me )
my problem is when i select an ID in the sheet 1 i want to clear this selection when moving to sheet 2 or 3.
Help.
Thank you,
Hello,
You can try this:
>> Right click with your mouse on "Sheet1"
>> Sheet Properties
>> The last tab after security (which should be something like trigger or shooter, i have Qlikview on my language)
>> Then "add actions" when leaving the sheet
>> Add >> Selection >> Delete Field and then you can select your field (ID)
I hope it helps you
Greetings!
Settings
Sheet Properties
Triggers
OnLeaveSheet >> Add Action
Add
Selection
Clear All
Hello,
You can try this:
>> Right click with your mouse on "Sheet1"
>> Sheet Properties
>> The last tab after security (which should be something like trigger or shooter, i have Qlikview on my language)
>> Then "add actions" when leaving the sheet
>> Add >> Selection >> Delete Field and then you can select your field (ID)
I hope it helps you
Greetings!