topic Re: num in qlikview format in QlikView

num in qlikview format

fkeuroglian — Mon, 26 Jan 2026 16:26:21 GMT

i am load a csv, but some field like IMPORTE1 doing num function does not transform in num

attached a qvw , the field IMPORTE1 is a text but in the load i am converting to num

what could be?

Thank you

Fernando

Re: num in qlikview format

ecolomer — Wed, 14 Jan 2015 19:52:42 GMT

Trata de eliminar, por si los hay caracteres diferentes de los números con:

Num(Keepchar (importe1, '1234567890.,')) as importe

Re: num in qlikview format

MarcoWedel — Wed, 14 Jan 2015 19:54:37 GMT

Hi Fernando,

Num(Num#(@13, '#,##0.00' ,'.',','), '#.##0,00') as importe1

the decimal separator can't be set with the format string, it has to be defined with a separate parameter in the num#() and num() functions if different from the default setting (like in your case: SET DecimalSep=',';)

hope this helps

regards

Marco

Re: num in qlikview format

Clever_Anjos — Wed, 14 Jan 2015 19:56:00 GMT

you´re mixing decimal separators

Your data uses '.' as decimal separator

You app uses ',' as decimal separador

SET ThousandSep=',';

SET DecimalSep='.';

at beginning of your code should solve this

OR use

purgechar(@13, '.,' )/100 AS importe1,