topic AW:Setting field as variabel in script in QlikView

Setting field as variabel in script

Tue, 10 Nov 2009 20:36:52 GMT

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

AW:Setting field as variabel in script

Wed, 18 Nov 2009 19:24:38 GMT

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

AW:Setting field as variabel in script

Wed, 18 Nov 2009 20:15:02 GMT

Thank you. This works.