topic Disabling a filter within a chart in QlikView

Disabling a filter within a chart

Tue, 11 Feb 2014 10:09:27 GMT

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 — Tue, 11 Feb 2014 10:12:21 GMT

Indeed, set analysis is the solution.

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

Michael

preminqlik — Tue, 11 Feb 2014 10:18:26 GMT

u can use set to remove that filter

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

it removes "fieldname" filter

Tue, 11 Feb 2014 11:40:04 GMT

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

Tue, 11 Feb 2014 11:43:00 GMT

Hi Varum,

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

Tue, 11 Feb 2014 11:44:37 GMT

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