Make chart only apply 1 filter

[#1]

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

[jerem1234 · Accepted solution]

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!

[Oleg_Troyansky]

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

[#4]

Perfect, way simpler. Thanks!

[#5]

Perfect, way simpler. Thanks!