num in qlikview format

[fkeuroglian]

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

[ecolomer]

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

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

[MarcoWedel · Accepted solution]

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

[Clever_Anjos]

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,