Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Get selected fields, alternate states and expressions in charts

After setting up list boxes with alternate groups I now want to call the selections in a chart expression.

my code is:

Sum({$<{[OHRO]}[MARKET RISK: NOTE: on target + overdue = LIVE ISSUES]={'Red Threshold'},Getselectedfield from {[OHRO]}[Group]>}Data)

But I cant figure the item in red?

How do I 'getselectedfield'

Neil

10 Replies
morganaaron
Specialist
Specialist

Hi Neil,

I understand what you're asking, but it might be more helpful to go back to what you're first trying to achieve here.

How many states do you have? And what state is the chart in that you're mentioning? What do you want to be happening? If you can explain as fully as possible I can try and reference your questions in regards to what you want to use.

P() works to limit the calculation to only those selections that are possible in your given selected state - so rather than needing to select something from group, if group was a subset of a ABC and you selected a value in ABC, then only the groups that are possible from that selection would pass across, if that makes sense!