Filter that works for one particular object only a... - Qlik Community

Report Inappropriate Content · ‎2013-04-21

I am creating Dashboard with multiple tabs. Will have filter page on beginning which should filter all the tabs. One of tab is pivot table where I want to create filter(multibox, or list box) which will filter that table only. But this multibox filters whole tab. Is ther away to create multibox that will filter only pivot table on that sheet. But main filter page should also work in pivot table. I have tried alternate state on multibox and pivot table looked like it worked but the main filter page filter wont be applied to Pivot table. Does anybody have any ideas on this topic?

sushil353 · ‎2013-04-21

Try this:

create a trigger on leave sheet:

while leaving the sheet clear the fields from multibox.

in this way your global filter would be applicable to your pivot tab and when you leave that sheet the multibox selections will be cleared.

HTH

Sushil

Oleg_Troyansky · ‎2013-04-22

If you define your "special" filter using an Alternative State, it will overlap with the "common" filters. You can use Set Analysis and define how the two states should co-exist (using intersection of the two states, or overriding certain fields...)

Ask me about Qlik Sense Expert Class!

narender123 · ‎2013-04-22

Hi Subash,

suppose your filter name is 'city'.

you can do only one thing in all table expreesion where you dont want to filter that table.

in set analysis expression write

=sum({<.....,city=>}amount)

means you have to write only city= where you dont want to effect that filter in table expression.

Report Inappropriate Content · ‎2013-04-23