Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

function to Remove heading zero from number

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.

2 Replies
sivarajs
Specialist II
Specialist II

num(Value)

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Num(DimensionName)

Regards,

Jagan.