Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?

3 Replies
Kushal_Chawda

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

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