https://community.qlik.com/t5/App-Development/Stop-qliksense-from-removing-leading-zeros/m-p/1758408#M58579 <P>Hi All,</P><P>While loading my data from SQL , i have a field ID and it contains values like 002345,0002345, etc</P><P>after loading data from SQL to qlik, qlik is removing leading zero from field value and making both the values same 002345,002345.</P><P>How to stop qlik from removing leading zeros from field values.</P> Sat, 16 Nov 2024 17:52:47 GMT Kaka1 2024-11-16T17:52:47Z https://community.qlik.com/t5/App-Development/Stop-qliksense-from-removing-leading-zeros/m-p/1758408#M58579 <P>Hi All,</P><P>While loading my data from SQL , i have a field ID and it contains values like 002345,0002345, etc</P><P>after loading data from SQL to qlik, qlik is removing leading zero from field value and making both the values same 002345,002345.</P><P>How to stop qlik from removing leading zeros from field values.</P> Sat, 16 Nov 2024 17:52:47 GMT https://community.qlik.com/t5/App-Development/Stop-qliksense-from-removing-leading-zeros/m-p/1758408#M58579 Kaka1 2024-11-16T17:52:47Z https://community.qlik.com/t5/App-Development/Stop-qliksense-from-removing-leading-zeros/m-p/1758409#M58580 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/119933">@Kaka1</a>&nbsp;</P><P>Try with Text() function</P><P>Ex: Text(FieldName) as FieldName</P> Wed, 04 Nov 2020 12:10:26 GMT https://community.qlik.com/t5/App-Development/Stop-qliksense-from-removing-leading-zeros/m-p/1758409#M58580 MayilVahanan 2020-11-04T12:10:26Z