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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.