Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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;