Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Disabling a filter within a chart

Hello,

Not sure if anybody have faced this problem:

Basically I want to disable some of the filters in particular chart. I know about 'alternate state' but this is duplicating most of the filters.

My dashboard has multiple chart and creating alternate state for all of them would be very messy.

Is there a way or formula(may be set analysis) which I can use to disable any filter for any chart?

Thanks,

Varun singhal


Tags (1)
1 Solution

Accepted Solutions
preminqlik
Valued Contributor II

Re: Disabling a filter within a chart

u can use set to remove that filter

for eg: sum({<[fieldname]=>}Sales)

it removes  "fieldname" filter

5 Replies
agilos_mla
Contributor III

Re: Disabling a filter within a chart

Indeed, set analysis is the solution.

More info how to use or write the syntax in your expressions : Set Analysis: syntaxes, examples

Michael

preminqlik
Valued Contributor II

Re: Disabling a filter within a chart

u can use set to remove that filter

for eg: sum({<[fieldname]=>}Sales)

it removes  "fieldname" filter

Not applicable

Re: Disabling a filter within a chart

Thanks Prem, This seem to be working for one filter but what if I have to disable two filters at a time?

Kind Regards,

Varun

Not applicable

Re: Disabling a filter within a chart

Hi Varum,

There are no problem to stack several fields in the set analysis to "remove the selection" on those fields in the chart

Not applicable

Re: Disabling a filter within a chart

I think I figured that out..

So I wrote

sum({<[fieldname]=,[fieldname2=>}Sales

Thanks a lot.. I am closing this thread.

Kind Regards,

Varun Singhal

Community Browser