topic Re: function to Remove heading zero from number in QlikView

function to Remove heading zero from number

Wed, 05 Jun 2013 06:40:21 GMT

Hello,

I want help to find out function which can remove heading 0's from number.

if this is number 00000004578 then it should appear in 4578.

But when number increases i.e 0099 to 0100 that should also captured.

pls Help

Thank U.

sivarajs — Wed, 05 Jun 2013 06:46:30 GMT

num(Value)

jagan — Wed, 05 Jun 2013 06:57:54 GMT

Hi,

Use Num(), it removes the leading 0s and returns the number.

Num(DimensionName)

Regards,

Jagan.