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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How To Remove Leading Zeros in a Number


Hi All,

I have a field with the following values

00000978

00001524

00001024

00012356

The field is in number format.

The length of the field is constant and it is 8.

I would like to remove the leading zeros and would like to have the values as follows:

978

1524

1024

12356

Kindly help me to get the above output.

Thanks in Advance!!

Regards,

Vinitha.

10 Replies
JeromeNagarro
Partner - Contributor II
Partner - Contributor II

Text(Alt(FieldName + 0, FieldName)) as FieldName