topic Re: How to apply common filter for all tabs in QlikView

How to apply common filter for all tabs

Tue, 30 May 2017 04:22:57 GMT

Dear all,

I have 20 tabs and one summary page (tab), In summary page having a filter, same filters are available in remaining 20 tabs.

If I select the filter in summary page, these filter will be applied to all 20 tabs.

How can I apply a common (Global) filter for all in QlikView?

Re: How to apply common filter for all tabs

Digvijay_Singh — Tue, 30 May 2017 04:35:08 GMT

By default Qlikview apply filters across application, in all tabs. Not sure if I understood your question properly?

Re: How to apply common filter for all tabs

Tue, 30 May 2017 04:37:30 GMT

Sorry, I'm not understanding your reply.

Re: How to apply common filter for all tabs

tresB — Tue, 30 May 2017 04:38:33 GMT

Qlik's default behavior is itself so. Unless you create alternate states and apply them for sheets, by default one selection in one sheet gets applied to all sheets available in your qv document.

Re: How to apply common filter for all tabs

Digvijay_Singh — Tue, 30 May 2017 04:40:55 GMT

When You select a value from a filter box, it will be applied in all tabs of your application.

Re: How to apply common filter for all tabs

Tue, 30 May 2017 04:42:56 GMT

Yes, that's true Digvijay, please provide me with an example.

Re: How to apply common filter for all tabs

Digvijay_Singh — Tue, 30 May 2017 04:49:37 GMT

Suppose you have a Product Name filter in one or more tabs, when you select One or more products from the filter(list box) , lets say in your summary tab or any other tab having the product list box, all of your charts, tables etc will show data for that product only(Provided you have not used set expression to disregard your selections).

Re: How to apply common filter for all tabs

Tue, 30 May 2017 04:58:06 GMT

Yes, what you said it's true - my scenario is same. When I select filter(Product) under the List box corresponding product values(Chart, Report) should be filtered in all tabs. But in my case 1-20 tabs, It filtered only 15 tabs but remaining 5 tabs no changes, it means those 5 tabs filter is not working.

Re: How to apply common filter for all tabs

tresB — Tue, 30 May 2017 05:05:19 GMT

Check if there is any Alternate State applied in those tabs/sheets, like:

learn more about it here: Alternate States ‒ QlikView

Re: How to apply common filter for all tabs

Anil_Babu_Samineni — Tue, 30 May 2017 05:08:11 GMT

Some how, Behavior helps like below

Check these

1) Alternate states

2) Lock Systems

3) Triggers

Even though, Qlik has benefit like associative to each and every object

Re: How to apply common filter for all tabs

Digvijay_Singh — Tue, 30 May 2017 05:08:13 GMT

May be set expressions or alternate states are used in those 5 tabs, which are disregarding the product filter in some way. If the expressions has section surrounded by {<>} or document properties--> alternate state showing different states in your document, check if they are causing this effect.

Re: How to apply common filter for all tabs

Tue, 30 May 2017 11:38:51 GMT

Hi Tresesco,

I did not see which is you mention Alternate State Drill down option in my dashboard.

Re: How to apply common filter for all tabs

Tue, 30 May 2017 12:13:18 GMT

Dear all,

I have not get correct answer yet

Re: How to apply common filter for all tabs

Digvijay_Singh — Tue, 30 May 2017 12:23:43 GMT

If you can share the document prop-->alternate state image and any chart

expression where filter is not applied, we may understand the situation

better. Thanks

Re: How to apply common filter for all tabs

abrahamparada — Tue, 10 Oct 2023 14:49:28 GMT

You need to create a trigger action in Document Properties to drive all selections in different sheet