Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Try:

$(=getfieldselections(YourExpressionsField))

Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Both perfect, thank you for helping