Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Re: Leading Zeros from Excel Load

Try using Verbatim

Verbatim ‒ Qlik Sense

SET Verbatim = 1;

Community Browser