Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Separate One Sheet In All Sheet (Filter)

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?

Labels (1)
3 Replies
Kushal_Chawda
MVP
MVP

I am still unclear. Do you want filter of one sheet should not affect on other sheet?

Not applicable
Author

Yes

i  want filter of one sheet should not affect on other sheet?

without Set Analysis And Alternate

Kushal_Chawda
MVP
MVP

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