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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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