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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove Leading Zeros

I have a field that can have anywhere from 1 to 5 leading zeros. What is the best way to remove them.

Thanks,
Stephen

Labels (1)
1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Use Num(FieldName)

Celambarasan

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Use Num(FieldName)

Celambarasan

Not applicable
Author

Yep, that did the trick. Thanks Celambarasan.

Stephen