topic Re: convert to number 2 in QlikView

convert to number 2

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

hi,

when i upload the attached excel file on Qlikview, i would like convert the second column SSCC to number.

even if sometime we can see a value of "????" in this column (we should ignore)

thanks

Re: convert to number 2

Lisa_P — Mon, 02 Dec 2019 22:38:49 GMT

try this in load script ..

Num(Evaluate(SSCC),'#0') as SSCC,

Re: convert to number 2

ahmedwank — Wed, 04 Dec 2019 09:45:50 GMT

thanks but unfortunately it doesnt work

Re: convert to number 2

tresB — Wed, 04 Dec 2019 09:55:50 GMT

May be just:

Evaluate(SSCC) as SSCCNum

If you need to exclude other values, you could try like:

load

Evaluate(SSCC) as SSCC

From <> where IsNum(Evaluate(SSCC));

Re: convert to number 2

Brett_Bleess — Wed, 11 Dec 2019 13:46:22 GMT

Did Lisa's last reply solve your problem? If so, please be sure to return to your post and use the Accept as Solution button on Lisa's last post to give her credit for the assistance and let other Community Members know this addressed your problem. If you require further assistance, please leave an update for us.

Regards,
Brett

Re: convert to number 2

veidlburkhard — Wed, 11 Dec 2019 16:01:21 GMT

Hi Ahmedwank,

why not simply ask if SSCC is numeric?

Like this:

T1:
LOAD N?,
If(IsNum(SSCC), SSCC) as SSCC
FROM
[C:\Users\Burkhard\Desktop\Kopie von ZPS2 1-9-19 au 15-9-19.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Then no values of SSCC with ???? are loaded.

Hope this helps.

Burkhard