Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
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


1 Solution

Accepted Solutions
preminqlik
Specialist II
Specialist II

u can use set to remove that filter

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

it removes  "fieldname" filter

View solution in original post

5 Replies
agilos_mla
Partner - Creator III
Partner - Creator III

Indeed, set analysis is the solution.

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

Michael

preminqlik
Specialist II
Specialist II

u can use set to remove that filter

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

it removes  "fieldname" filter

Not applicable
Author

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
Author

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
Author

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