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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variable in list box

Good afternoon community,

I would like to create a dynamic bar chart, where the expression changes based on the selection in a list box.

The list box contains the variables that form the expressions, which i have imported as an excel table.

e.g.

Var1 = sum(Page_Views)/sum(Sessions)

Var2 = Sum(Bounces)/Sum(Sessions)

I would like to know how to enter the field name in the chart to get the desired functionality.

I think it's a problem where I can't get the syntax right with the $$$$$$$$$

Any help will be greatly appreciated, I think i'm close to exhausting what i know!

Thanks,

Simon

3 Replies
marcus_sommer

Try:

$(=getfieldselections(YourExpressionsField))

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached example. Is that what you're looking for?


talk is cheap, supply exceeds demand
Not applicable
Author

Both perfect, thank you for helping