Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ALL,
How can i use alternate state with getfieldselections? Please post an example or expression.
Thanks a mill. Much appreciate that.
I have SR7 - can I just down the latest version?
Your are talking about the desktop client, right?
Yes, you should be able to download the latest QV 11.20 SR (12, I believe) fromt the Qlik download site.
If you are working in a company, might be advisable to check if there are any restrictions on downloading and using different QV versions.
Yes the desktop client.
I have a version on my own laptop but actually I remote into a client's
server, so they'd actually have to install it there.
Thanks for your help.
Hi
I'm having a different problem now with these alternate states and the drill down.
Because I have made the graph's state the default state to get the drill down to work, the filters on the sheet don't apply to my chart, which means I need to make all my list boxes part of the default state, which then basically means I'm not using an alternate state.
Can anyone help please? Is there a way to make sure the chart filters the data based on the sheet's alternate state and still have the drill downs working?
I am using this expression to make my dimension visible
=if(GetFieldSelections(DimGroup,';',10, 'GraphC') like '*Account*', true(), false())
Thanks
Absolutely awesome - fixed my issue
=Concat({[AlternateStateName]}DimensionName)
Thank you