topic Customize filter application in QlikView

Customize filter application

Fri, 17 Jan 2014 20:22:18 GMT

I have 4 Charts with the following fields

Chart 1 YEAR LOCATION ZONE

Chart 2 YEAR LOCATION ZONE NAME

Chart 3 YEAR LOCATION ZONE TITLE

Chart 4 YEAR LOCATION ZONE DEPT

When I apply filter for LOCATION = Houston

I want this filter to be applied only to Chart 1, 2, and 3

But if I apply filter for other fields ie. YEAR, ZONE NAME ETC.. the filter should be applied to all the Charts. Is this possible?

Nicole-Smith — Fri, 17 Jan 2014 20:38:28 GMT

In your expression on the chart you do not want LOCATION to be included on (Chart 4) you can put the following in your set analysis:

{<LOCATION=>}

So your expression should look something like:

sum({<LOCATION=>} Sales)

This will ignore any selections in the LOCATION field.

Fri, 17 Jan 2014 21:02:59 GMT

Thank you very much.