Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaka1
Contributor
Contributor

Stop qliksense from removing leading zeros

Hi All,

While loading my data from SQL , i have a field ID and it contains values like 002345,0002345, etc

after loading data from SQL to qlik, qlik is removing leading zero from field value and making both the values same 002345,002345.

How to stop qlik from removing leading zeros from field values.

Labels (2)
1 Solution

Accepted Solutions
MayilVahanan

Hi @Kaka1 

Try with Text() function

Ex: Text(FieldName) as FieldName

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

Hi @Kaka1 

Try with Text() function

Ex: Text(FieldName) as FieldName

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.