topic Re: Issue with text values dropping leading zero in QlikView

Issue with text values dropping leading zero

l_palacios — Mon, 26 Jan 2026 18:19:17 GMT

I have an output issue where a text value that has a leading zero gets converted to numeric and the zero is dropped whenever a file exceeds 50000 rows of data in excel. Is there a way to fix this? I have updated document preferences in the presentation section to treat as "mixed" as well as the properties in the pivot tables. It only happens when the export exceeds 50k and exporting to excel. Is there a workaround or a fix for this?

Re: Issue with text values dropping leading zero

Gysbert_Wassenaar — Mon, 18 May 2015 16:38:44 GMT

It probably happens when you have more than 65536 records. That's when Qlikview starts exporting to csv format. CSV doesn't contain formatting so no leading zero's.

Try reading some of the results from this search: https://community.qlik.com/search.jspa?q=leading+zero+export+format

Perhaps one of the solutions is what you're looking for.

Re: Issue with text values dropping leading zero

l_palacios — Mon, 18 May 2015 16:47:13 GMT

Thank you. Will start reading through that link. I do have more than 65k rows that I need returned. How can this be handled to include all the rows?

Re: Issue with text values dropping leading zero

petter — Mon, 18 May 2015 16:57:12 GMT

If you have character columns or text values from a source you should always tell QlikView not to interpret the values but keep them as text by wrapping the column/field in the Text()-function ... then it should stay as text in QlikView too.

LOAD

Text(product_id) AS product_id,

....

FROM

[Products.XLSX] ....

Actually I always recommend people to do that to make sure that QlikView doesn't mess up your character/text fields by misreading them as numbers... QlikView is a bit too eager to be helpful sometimes - but this is mistaken politeness.

Just tell QlikView - thank you - but no thanks by using the Text()-function.

Re: Issue with text values dropping leading zero

petter — Mon, 18 May 2015 17:07:28 GMT

Is it an XLSX-file you are reading? I can't seem to reproduce your problem... reading much more than 50000 rows without a problem and if it is really a text in Excel it is read in as text in QlikView and keeping the leading zeros too.

Re: Issue with text values dropping leading zero

Gysbert_Wassenaar — Mon, 18 May 2015 17:12:20 GMT

You're looking at the wrong end of the beast. He's exporting, not importing.

Re: Issue with text values dropping leading zero

petter — Mon, 18 May 2015 17:17:32 GMT

sorry about that ...

Re: Issue with text values dropping leading zero

l_palacios — Mon, 18 May 2015 19:59:13 GMT

No Worries ☺.

Re: Issue with text values dropping leading zero

l_palacios — Wed, 27 May 2015 14:35:20 GMT

this was helpful as well for another issue. Thanks.