Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
philmywallet
New Contributor III

Alternate State ... Not All Selections

Hi

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

1 Solution

Accepted Solutions

Re: Alternate State ... Not All Selections

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

5 Replies

Re: Alternate State ... Not All Selections

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

philmywallet
New Contributor III

Re: Alternate State ... Not All Selections

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

Re: Alternate State ... Not All Selections

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

laddu_927
Valued Contributor

Re: Alternate State ... Not All Selections

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.

philmywallet
New Contributor III

Re: Alternate State ... Not All Selections

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

Many thanks

Phil

Community Browser