topic Re: Use a variable with decimals for arithmetic calculation in script in App Development

Use a variable with decimals for arithmetic calculation in script

Oliver_GER — Wed, 21 May 2025 17:55:32 GMT

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.

Re: Use a variable with decimals for arithmetic calculation in script

tw_wipro — Wed, 21 May 2025 18:21:10 GMT

Hi Oliver,

what about this:

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

Re: Use a variable with decimals for arithmetic calculation in script

Oliver_GER — Wed, 21 May 2025 18:33:12 GMT

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!