Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
With Alternate States for comparative analysis.
Look at this document:
Hope this helpshttp://www.resultdata.com/using-alternate-states-in-qlikview-11/
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.
Thank you very much! It worked!
Glad i could help