Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello dears
i have many sheets in qlikview
i have one sheet that not filter Other terms sheet
I do not want a filter sheet by another sheet(without Set Analysis)
Is there a way?
I am still unclear. Do you want filter of one sheet should not affect on other sheet?
Yes
i want filter of one sheet should not affect on other sheet?
without Set Analysis And Alternate
Suppose you have sheet1 , sheet2 & sheet3 and filters of sheet1 should not affect on sheet2 & sheet3 then do as follows
1) Go to sheet 2 & Sheet 3 -> Right click on sheet -> Go to properties -> Go to Triggers tab ->
OnActivateSheet -> Add action-> Selection ->Action-> Clear all
This will clear all the selections of Sheet1 when you go to sheet 2 & sheet3
Now suppose you don't want all filters to clear, you can specify the Fields in Clear Field action