Discussion Board for collaboration on QlikView Layout & Visualizations.
Sasi K Sasi
I have small issue on my stright table .
i have stright table with triggers and wen i select the value in table[Project] it shud go to next sheet that is very much fine.
but wen i came back to the my table sheet the selection should not be there
i.e it clears all selections?
How to achve?
Thanks in advance.
Go to Solution.
Do you want Clear All value when you come back in Main Sheet?
May be try with the Trigger OnActivateSheet -> Clear All
You could set the trigger on the sheets also , try like this
Go to sheet properties> Tiggers >and set triggers for > select on activate and on sheet leave
Hope this helps you
Try like this
Sheet properties -> Trigger -> OnActivateSheet -> Clear All
Or, change the trigger based on your requirement. (ie,. Clear only one field, clear all., etc)
You can clear all the selections you are back to the sheet using the Sheet Level Triggers like below
but i hve four sheets in my original qvw.
so i want in only one sheet values shud be cleared.? how it is psbl?
means: i hve seleted in table and cme bak its clear all no issues.
but wen i made any selection on other sheet and come bak to this sheet here also no selection availbe? so how can i achve this?
yeah jagan. but i need only perticular sheet only ... but its making clear to all selection in other sheets also.
Could you please say your requirement with example. its little bit confusing..
If you clear one field value in any sheet, its reflect in whole dashboard.
yeah dat is wat i dnt want....onle one sheet values shud be clear all?
Filter objects are not restricted to a sheet, it is across a Dashboard level the selections carries across all sheets, if you clear in one sheet it will clear in all sheets.
The workaround for this is create new field from the existing field like below
Field1 AS Field2
Now use this field in your sheet and clear it when you are coming to the sheet instead of clearing all the selections.