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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export Variable Overview variables to a QlikView table

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

3 Replies
Not applicable
Author

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.

Not applicable
Author

Just put your variable between ' '

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

Not applicable
Author

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.