Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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

Try using Verbatim

Verbatim ‒ Qlik Sense

SET Verbatim = 1;