Use a variable with decimals for arithmetic calculation in script

[Oliver_GER]

Hi,

I feel a little stupid asking this question - anyway I need your help with this.

SET ThousandSep='.';
SET DecimalSep=',';

let vVar = 8/7; //=1,1428571428571
trace vVar: $(vVar);

Table:
load
    $(vVar) * 10 as test
AutoGenerate 10;

What Qlik does here using dollar sign expansion is the following:

Table:
load
    1,1428571428571 * 10 as test
AutoGenerate 10;

And this is interpretated as this:

Table:
load
    1,
    1428571428571 * 10 as test
AutoGenerate 10;

So I end up getting a table with two fields. I tried to play around with different number formattings, but nothing works, because I do have to keep the accuracy of vVar.

[tw_wipro · Accepted solution]

Hi Oliver,

what about this:

Table:
load
    $(vVar) * 10 as test
    ,'$(vVar)' * 10 as test2
AutoGenerate 10;

[Oliver_GER]

THANK YOU! it was so easy. - I have to admit I do not fully understand, why qlik is still able to to calculate with it (it even works with timestamps) when we wrap it in single quotes, but it works. great!