Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
maybe:
Num(SSCC, '#################')
?