topic Leading Zeros from Excel Load in App Development https://community.qlik.com/t5/App-Development/Leading-Zeros-from-Excel-Load/m-p/1104745#M18739 <HTML><HEAD></HEAD><BODY><P>Hey folks, I'm loading an excel workbook into QlikSense, and trying to figure out how to maintain the leading zeros in a column. The column has item numbers within in, which are 7 digits for us, and often have between 1-4 leading zeros. The workbook load is pure data, no pivots.</P><P></P><P>Any idea how I prevent an app from auto-cropping the item # down? Thanks-</P><P></P><P>Drew</P></BODY></HTML> Wed, 06 Jul 2016 19:15:40 GMT 2016-07-06T19:15:40Z Leading Zeros from Excel Load https://community.qlik.com/t5/App-Development/Leading-Zeros-from-Excel-Load/m-p/1104745#M18739 <HTML><HEAD></HEAD><BODY><P>Hey folks, I'm loading an excel workbook into QlikSense, and trying to figure out how to maintain the leading zeros in a column. The column has item numbers within in, which are 7 digits for us, and often have between 1-4 leading zeros. The workbook load is pure data, no pivots.</P><P></P><P>Any idea how I prevent an app from auto-cropping the item # down? Thanks-</P><P></P><P>Drew</P></BODY></HTML> Wed, 06 Jul 2016 19:15:40 GMT https://community.qlik.com/t5/App-Development/Leading-Zeros-from-Excel-Load/m-p/1104745#M18739 2016-07-06T19:15:40Z Re: Leading Zeros from Excel Load https://community.qlik.com/t5/App-Development/Leading-Zeros-from-Excel-Load/m-p/1104746#M18740 <HTML><HEAD></HEAD><BODY><P>Try using Verbatim</P><P><A href="https://betahelp.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/Scripting/SystemVariables/Verbatim.htm" title="https://betahelp.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/Scripting/SystemVariables/Verbatim.htm">Verbatim ‒ Qlik Sense</A>‌</P><P></P><P><STRONG>SET Verbatim = 1;</STRONG></P></BODY></HTML> Wed, 06 Jul 2016 20:04:06 GMT https://community.qlik.com/t5/App-Development/Leading-Zeros-from-Excel-Load/m-p/1104746#M18740 sunny_talwar 2016-07-06T20:04:06Z