Setting field as variabel in script

[#1]

Hello,

I have a transactions table that contains fields with keyfigures as gross sales, sales, margin.

I would like to create a selection box where the analyser just has to choose the keyfigure he would like to see in the charts. The chart expressions would than only contain the variable. e.g. Sum(varKeyFigure) in stead of Sum(Gross_Sales).

How can I create this in the script?

Thanks for your help

[#2 · Accepted solution]

Hi,

try it with this:

Load the Names of the keyfigures inline.

Make a variable and allocate the value of the loaded keyfigure name.

then you can use the variable in the sum()

-> see attached

Have Fun with qlik

Alex

[#3]

Thank you. This works.