Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Just put your variable between ' '
Variables:
Load * inline
[
qlik_id,static_evalue
6.6,'$(test)'
];
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.