topic Re: Alternate State ... Not All Selections in QlikView

Alternate State ... Not All Selections

Anonymous — Thu, 30 Mar 2017 13:11:32 GMT

Please can someone advise me how I can use alternate state for only some of my lists, but still include an inherited state also.

e.g.

I have 3 list boxes for Month, Level1 & Level2.

I would like the Level1 & Level2 to be an alternate state so that it doesn't affect any of the other charts in the dashboard, but I also want to keep the selection based on the inherited state for the month.

I can't use an alternate state for the Month as I want the month to applied to all my other charts.

So I want the month selection to apply to all charts (including my specific chart), but I want the level1 & Level2 to only apply to my specific chart.

Thoughts

Cheers

Phil

Re: Alternate State ... Not All Selections

sunny_talwar — Thu, 30 Mar 2017 13:14:51 GMT

May be this

Sum({<Level1 = AS::Level1, Level2 = AS::Level2>}Measure)

Where your chart is going to be in the inherited state and AS is the name of your alternate state

Re: Alternate State ... Not All Selections

Anonymous — Thu, 30 Mar 2017 13:18:13 GMT

That wont work as all my other charts will be affected by the selection for Level1 & Level2.

Re: Alternate State ... Not All Selections

sunny_talwar — Thu, 30 Mar 2017 13:19:35 GMT

Why would that be? If you are selecting in Alternate state for Level1 and Level2? Or is Level1 and Level2 one of the dimensions?

Re: Alternate State ... Not All Selections

Anonymous — Thu, 30 Mar 2017 13:23:42 GMT

Maybe we can keep Level1 and Level2 in different alternate state and write expressions in that specific chart of yours to filter based on the lists from different state..

Filter data for only selected charts

might help you.

Re: Alternate State ... Not All Selections

Anonymous — Fri, 31 Mar 2017 05:50:29 GMT

Apologies this does work fine. It was a long day yesterday.

Many thanks

Phil