Stop qliksense from removing leading zeros

[Kaka1]

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.

[MayilVahanan · Accepted solution]

Hi @Kaka1 

Try with Text() function

Ex: Text(FieldName) as FieldName