Number format

[#1]

Hi All,

I have a field which is numeric in nature. When I am loading the field from excel spreadsheet, Qlikview is adding leading 0 ( zero) in front of the number. I don't want these 0's to be added in the front. For eg: the field CYCM has a value of 85168. When loaded in Qlikview, it shows as 0000000085168.

How can I restrict Qlikview to show it as 85168 after loading in QVW without the 0's during load time. I can change the number settings in the list box, but I don't want to go there. Want to load it as is.

All your help will be appreciated.

Thanks,

Tutan

[CELAMBARASAN · Accepted solution]

Did you checked with simply Num(FieldName)?

It looks like it loads as a Text not as a number.

[MayilVahanan]

HI

Try like this

Num() function or num#() function.