Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Leading Zeros from Excel Load

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.

Any idea how I prevent an app from auto-cropping the item # down? Thanks-

Drew

1 Reply
sunny_talwar
MVP
MVP

Try using Verbatim

Verbatim ‒ Qlik Sense

SET Verbatim = 1;