Disabling a filter within a chart

[#1]

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

[agilos_mla]

Indeed, set analysis is the solution.

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

Michael

[preminqlik · Accepted solution]

u can use set to remove that filter

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

it removes  "fieldname" filter

[#4]

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

[#5]

Hi Varum,

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

[#6]

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