convert varchar to num and add 100000 to the field

[ashmitp869]

Hi there ,

I have a varchar(20) datatype field in db,

I have convert that field in qlikview to number and add  100000 to that field ?

Can I write the script like this -

AP:
LOAD  Num(Admission No) + 100000 as "Admission No",
MRN,

date

From 

qvd;

Thanks

[Vegar · Accepted solution]

Yes, the

 Num("Admission No") + 100000 as "Admission",

should work.

I would even assume that 

"Admission No" + 100000 as "Admission"

should work. 

[Volkman]

This works by using the CONVERT function to convert the number from MONEY to a VARCHAR with a style of 1, which adds the commas and also a decimal point and two decimal places. As we don't really want the decimal places I've used the REPLACE function to strip them off.

mygiftcardsite balance