Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read 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
Partner - Champion III
Partner - Champion III

Hi,

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

Num(DimensionName)

Regards,

Jagan.