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?
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.
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.
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.
He's exporting, not importing.
sorry about that ...