convert to number

[ahmedwank]

hi

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]

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]

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 · Accepted solution]

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]

maybe:

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

?