Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ahmedwank
New Contributor II

convert to number 2

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

 

3 Replies
Employee
Employee

Re: convert to number 2

try this in load script ..

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

 

 

ahmedwank
New Contributor II

Re: convert to number 2

thanks but unfortunately it doesnt work

MVP
MVP

Re: convert to number 2

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));