Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
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

View solution in original post

1 Reply
MayilVahanan

Hi @Kaka1 

Try with Text() function

Ex: Text(FieldName) as FieldName

Thanks & Regards,
Mayil Vahanan R

View solution in original post