Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unlink filter

Hi Everyone,

Is it possible to unlink the filters between sheets? I don't the selection in one sheet to affect another sheets.

7 Replies
vikasmahajan

you can give sheet trigger ->on activate sheet -> Clear Field -> Give field (Filer name to clear)

Hope this helps you

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

Hi Vikas, Thanks for your help, But I am use Qlik sense desktop, I think it is quite different from qlik view:)

arulsettu
Master III
Master III

both sheets are sharing data from same table?

undergrinder
Specialist II
Specialist II

Hi Lingling,

As default the filters have effect on every page.

You can simulate unlinking filters by:

  • This sheet navigation extension has Clear selection option at sheet navigation Qlik Branch
  • Or create different tables to different sheets. The filters will be stay at selections pane, but haven't got effect on data.

G.

Not applicable
Author

Yes, the exact same data

Not applicable
Author

Or if you want to maintain different selections on each sheet, you might have to use Alternate State extension

Re: Comparative Analysis - Alternate States with Qlik Sense

But this will be a bit painful to maintain all objects to assign to the correct State.

it also depends on what you want to do exactly. You can add the same field in script to multiple field names. For ex:

Country as Country,

Country as Country1,

So sheet1 use Country filter, sheet2 use Country1 filter and then in your expresion, you might need to exclude Country or Country1 selections. Again, this will add extra works for you.

Or the Clear selection at sheet navigation option mentioned above.

This is just different suggestions, depends on your scenario, you can decide what to do.

rajeshvaswani77
Specialist III
Specialist III

Hi,

You can consider using set analysis to make it insensitive to filters.

Thanks,

Rajesh Vaswani