topic convert to number in QlikView

convert to number

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

i would like convert the second column SSCC to number and in this column there is sometime a value of "????" that we should ignore

i tried to put in script num(SSCC) but it doesnt work

please find here attached a small file

if you can help

thanks

Taoufiq_Zarra — Wed, 27 Nov 2019 13:51:47 GMT

Hi,

try this solution

in the script you will add this code

Num(Num#(replace(SSCC,',','.'),'#', '.', ','), '(dec)') as New_SSCC

because a classical formatting does not allow to interpret the SSS column as a number

this code will work well, see result below :

cheers,

Taoufiq

ahmedwank — Wed, 27 Nov 2019 14:09:00 GMT

thanks Taoufiq for helping

unfortunately even when i add this code on my script that doesnt work

it seems that the New_SSCC column is empty

please see attached picture

Taoufiq_Zarra — Wed, 27 Nov 2019 14:22:07 GMT

did we work with the same source file?

I tested the function in Qlikview and Qliksense and it works with the sample data you sent

sebastianfaust — Wed, 27 Nov 2019 14:26:55 GMT

maybe:

Num(SSCC, '#################')