topic Re: Loading a Value in QlikView

Loading a Value

danfuer123 — Tue, 02 Feb 2021 19:23:19 GMT

Hi there,

trying to load a calculated value, it is a decimal value, seperated with a comma. for example (0,25555) and getting always that error!

What am I doing wrong??

Also tried the num Function, and getting the same problem!!

It's obvious that a decimal load is somehow not working !

You can see the Error an the Source code below!!

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Syntax error
Unexpected token: ',', expected one of: ')', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', ...
aa:
LOAD
3809682 as Auftrag_ID1,
text('0,2223') as dauer_Tag_1,
text(0>>>>>>,<<<<<<29166666666424) as dauer_Tag_2
//$(dauer_dat) as dauer_datum
Resident Incident_1 where 1 = RecNo()

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Source Code
aa:
LOAD
$(ID1) as Auftrag_ID1,
text('0,2223') as dauer_Tag_1,
text($(dauer_erst_Tag)) as dauer_Tag_2
//$(dauer_dat) as dauer_datum
Resident Incident_1 where $(i) = RecNo();

Re: Loading a Value

edwin — Tue, 02 Feb 2021 20:33:00 GMT

could it be you have a different setting for decimals? check this line in the first few lines of your script:

SET DecimalSep='.';

if you want to use comma, just replace that otherwise change the decimal separator in the NUM function:

Num - script and chart function ‒ QlikView

Re: Loading a Value

MayilVahanan — Wed, 03 Feb 2021 02:24:32 GMT

Hi @danfuer123

Try with single quotes in the variable declaration.

text('$(dauer_erst_Tag)') as dauer_Tag_2

Re: Loading a Value

danfuer123 — Wed, 03 Feb 2021 10:04:16 GMT

Thank you guys!!

The solution is : '$(dauer_dat)' as Inc_Dauer_Datum_hh

dauer_dat: is a decimal value i.e.: 0,0001

I haven't put them into the quotes ' ', that was the only case!