topic Re: Separate One Sheet In All Sheet (Filter) in QlikView

Separate One Sheet In All Sheet (Filter)

Sat, 22 Aug 2015 09:36:00 GMT

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?

Kushal_Chawda — Sat, 22 Aug 2015 10:56:52 GMT

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

Sat, 22 Aug 2015 11:19:26 GMT

Yes

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

without Set Analysis And Alternate

Kushal_Chawda — Sat, 22 Aug 2015 11:40:06 GMT

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