topic Re: Make chart only apply 1 filter in QlikView

Make chart only apply 1 filter

Tue, 25 Feb 2014 17:38:49 GMT

I have a sheet with 3 carts and 3 filters. I need 2 of the charts to use all 3 of the filters, but one chart only uses the Date filter.

Filter 1 (Date)

Filter 2

Filter 3

Chart 1 (only apply Date filter)

Chart 2 (apply all filters)

Chart 3 (apply all filters)

I see some references to using Alternate states, but I am a little unclear now I apply filter 1 to multiple states (something like this):

Filter 1 (Date) - State A and State B

Filter 2 - State B

Filter 3 - State B

Chart 1 (only apply Date filter) - State A

Chart 2 (apply all filters) - State B

Chart 3 (apply all filters) - State B

Ideally, to simplify I would leave everything with the default state except Chart 1 and Filter 1, and have Filter 1 apply to both the default state and State A.

Thanks for the advise.

Jessica

Re: Make chart only apply 1 filter

jerem1234 — Tue, 25 Feb 2014 17:43:42 GMT

Instead of alternate states, have you tried using set analysis to ignore selections made in your fields for filter 2,3 for your Chart 1?

Something like:

sum({<Field2=, Field3=>}Value)

Hope this helps!

Re: Make chart only apply 1 filter

Oleg_Troyansky — Tue, 25 Feb 2014 17:44:39 GMT

You can use Set Analysis in some of the charts to disregard selections in some of the filters:

sum({<Filter1=, Filter2=>} Sales)

In this example, Filters1 and 2 are ignored.

Oleg Troyansky

Come and learn advanced Set Analysis with me at the Masters Summit for QlikView - Chicago, April 1-3.

www.masterssummit.com

Re: Make chart only apply 1 filter

Tue, 25 Feb 2014 17:49:43 GMT

Perfect, way simpler. Thanks!

Re: Make chart only apply 1 filter

Tue, 25 Feb 2014 17:49:48 GMT

Perfect, way simpler. Thanks!