Discussion board where members can get started with QlikView.
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)
try this in load script ..
Num(Evaluate(SSCC),'#0') as SSCC,
thanks but unfortunately it doesnt work
May be just:
Evaluate(SSCC) as SSCCNum
If you need to exclude other values, you could try like:
Evaluate(SSCC) as SSCC
From <> where IsNum(Evaluate(SSCC));