topic Export Variable Overview variables to a QlikView table in QlikView

Export Variable Overview variables to a QlikView table

Tue, 08 Jun 2010 14:56:33 GMT

I have a variable (we'll call test) that I've created in the Variable Overview (test=10/100) . I want to export the result (.10) of that variable to a QlikView table so I can concatenate it with another table. Below Inline code almost gives me what I need except for the test variable shows the formula (=10/100) instead of the result (.10).


Variables:
Load * inline
[
qlik_id,static_evalue
6.6,$(test)
];

I'm probably missing something really easy. Any help would be much appreciated.

thanks,

rob

Export Variable Overview variables to a QlikView table

Tue, 08 Jun 2010 15:34:50 GMT

How are you defining test? I think you are probable saying:

Set test = 10/100;

Instead use:

Let test = 10/100;

That should force QlikView to evaluate the formula.

Export Variable Overview variables to a QlikView table

Tue, 08 Jun 2010 15:39:54 GMT

Just put your variable between ' '

Variables:
Load * inline
[
qlik_id,static_evalue
6.6,'$(test)'
];

Export Variable Overview variables to a QlikView table

Tue, 08 Jun 2010 15:50:29 GMT

I've posted a *.qvw so you can see how I'm defining things. The test variable is being defined in the Variable Overview (Settings/Variable Overview).

I tried putting quotes around the $(test) variable in my Inline statement like you mentioned above Erico, but it's still loading the formula from the Variable Overview instead of the result of the formula.