topic Re: How to calculate variables if decimal separator is set to comma in QlikView

How to calculate variables if decimal separator is set to comma

katkaKF — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

in my environment is decimal separator set as comma and I have problem with number variables. I created new QVW file, where I created new variable and displayed its value in Text Object:

SET ThousandSep=' ';
SET DecimalSep=',';
SET MoneyThousandSep=' ';
SET MoneyDecimalSep=',';
SET MoneyFormat='# ##0,00 €;-# ##0,00 €';

LET vTest = 1/10;

I have in in TextObject:

=$(vTest)

But it isn't displayed, I have an error: "Error: Garbage after expression:','". What did I wrong? If I change decimal separator in load script to dot (SET DecimalSep='.';), it works properly. Why is the result influenced by setting of the decimal separator? I thought, that DecimalSep is just a format that is used to display the value and not to evalueate it. I thought it has no effect during the calculations of the value.

If I have in load script SET DecimalSep=','; and in TextObject = num(vCoef, '#,##', '.', ','), it is displayed properly.
Does it mean, that I have to always use NUM function during calculations with variable, when I have decimal separator set to comma?

Thanks

Katka

Re: How to calculate variables if decimal separator is set to comma

lironbaram — Mon, 20 Apr 2020 09:39:25 GMT

if your variable is a static number

you can use =vTest

and if you have a formula you can for example sum(value*vTest)

Re: How to calculate variables if decimal separator is set to comma

katkaKF — Mon, 20 Apr 2020 10:11:54 GMT

I just want to know, whether it is necessary to know in the beginning of the creating the new project what number format will be used.

Has the setting of decimal separator influence of the way, how to work with variables? I think that is just a formatting matter and has no impact on the codeing. Am I wrong?

I have a Slider Object with variable. I have in script:

SET DecimalSep=',';

vCoef = 0;

In Slider Object I set this variable and on the Caption Tab I have Title Text:

=$(vCoef)

In the Chart I have What If expression set to:

SUM(UnitCost * UnitsBalance) + $(vCoef) * (SUM(UnitCost * UnitsBalance))

In variable overwie I can see, that the variable vCoef is set to 2,3 instead od 2.3 and int the title bar of slider is an error: "Error: Garbage after expression:',' " and the What If column in the chart is empty:

When I manualy change setting of the constant DecimalSep to dot:

SET DecimalSep='.';

it works. It also works, if I replaced vCoef with = num(vCoef, '#,##', '.', ',') and everything is correct, but I dont think that it is what I should do. Or is it?

Should I always use NUM if I work with calculated variable and DecimalSep is comma?

Thanks

Katka

Re: How to calculate variables if decimal separator is set to comma

lironbaram — Mon, 20 Apr 2020 16:57:59 GMT

try this first

in the title of the slider write : =vCoef

and in the chart

SUM(UnitCost * UnitsBalance) + vCoef * (SUM(UnitCost * UnitsBalance))

Re: How to calculate variables if decimal separator is set to comma

katkaKF — Mon, 20 Apr 2020 17:21:10 GMT

that works, wow!

But I am confused now, what is the difference between vCoef and $(vCoef)? What does it mean, that it is static number? I thought, that static number means, that it is a constant. In slider object the value of this variable is changing, and despite that is it a static number?

Thanks

Re: How to calculate variables if decimal separator is set to comma

lironbaram — Mon, 20 Apr 2020 18:42:33 GMT

the $(vCoef) calls for a calculation as variables might hold expressions or mathematical functions

if the variable is a number than you don't need the $ sign