You probably used the formatting in the "Numbers" tab in your object, I guess. My proposal is to import your data as text in your load script, TEXT(YourFigures) AS Field1. Maybe, the problem can be solved when you just go to Settings / Document Properties / Numbers and choose number format "Mixed" and "Survive Reload" in the settings for your field.
Does this work?
I'm back with the same question. I have tried all mentioned solutions ans none seem to work on a large dataset. I am exporting 400000 rows to excel and the leading zeros are getting dropped. if I limit the dataset, the 0's are present. I am at a loss of whta the issue may be. In my load from the qvd file the load is Load text(dialling code from file .qvd()qvd. I also adfd acalculated dimesion text(dialling code).
Any help would be appreciated.
The problem seems like QlikView trying to save memory (hence the issue only with bigger dataset) in a field that all it's records are numeric if the leading zeros are dropped.
I would try to load the field with text(field) (which has worked fine for me on a couple of ocasions) and check the tag assigned (Settings -> Document Properties -> Tables -> Fields). If it still is $numeric $integer edit it to $ascii, $text. If that doesn't work i would concatenate with an inline load with a space or something that would force QlikView to load the field in text mode.