Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make charts be affected by specific filters only?

I have three charts (Chart1, Chart2, Chart3) and 7 filters (Filter1, Filter2, Filter3, Filter4, Filter5, Filter6, Filter7).

Chart1 should be affected by all of the filters.

Chart2 and Chart3 should only be affected by Filter1, Filter2, Filter3.

So, for example, if i make a selection in Filter1, all of my charts should be affected. If i make a selection in Filter4, only Chart1 should be affected while Chart2 and Chart3 should stay the same.

Can you please advise of any solution how i can do this?

Thanks!

1 Solution

Accepted Solutions
lorenwood
Contributor III
Contributor III

Instead of Alternate States you may want to do something like this:

I have three charts (Chart1, Chart2, Chart3) and 7 filters (Filter1, Filter2, Filter3, Filter4, Filter5, Filter6, Filter7).

For Chart 1, do not need to do anything

For Chart 2 & 3 in set analysis you can do (example)

sum({< Filter4=,Filter5=,Filter6=,Filter7= >} Value)
So if any selections for Filter 4-7 are made they will not affect Chart 2 and 3. They will affect Chart 1 per your requirement.

View solution in original post

4 Replies
Not applicable
Author

With Alternate States for comparative analysis.

Look at this document:

Hope this helpshttp://www.resultdata.com/using-alternate-states-in-qlikview-11/

lorenwood
Contributor III
Contributor III

Instead of Alternate States you may want to do something like this:

I have three charts (Chart1, Chart2, Chart3) and 7 filters (Filter1, Filter2, Filter3, Filter4, Filter5, Filter6, Filter7).

For Chart 1, do not need to do anything

For Chart 2 & 3 in set analysis you can do (example)

sum({< Filter4=,Filter5=,Filter6=,Filter7= >} Value)
So if any selections for Filter 4-7 are made they will not affect Chart 2 and 3. They will affect Chart 1 per your requirement.

Not applicable
Author

Thank you very much! It worked!

lorenwood
Contributor III
Contributor III

Glad i could help