topic Leading 0 Export in QlikView

Leading 0 Export

azmeerrehan — Tue, 10 Oct 2017 13:54:24 GMT

I have a table with a Customer_ID field has leading zeroes in it for example (00123546). When I am exporting the table with any filters selected on the sheet , i get the correct Customer_ID with o's but if I export it without any filters I loose the leading zeroes. I dont know if its a bug or am I missing something here.

I have already tried Num(Field,'0000000') and Text(Field)

Any Help is appreciated

Re: Leading 0 Export

marcus_sommer — Tue, 10 Oct 2017 14:43:44 GMT

Does it also happens if you export to csv? If not it's an excel-feature.

- Marcus

Re: Leading 0 Export

azmeerrehan — Tue, 10 Oct 2017 15:29:23 GMT

Yes it does weather I do CSV or Excel I loose 0's

Re: Leading 0 Export

marcus_sommer — Tue, 10 Oct 2017 16:10:45 GMT

For me it worked. Important by it is to open the csv within an editor and not in excel (which always has some "useful" own-intelligence):

- Marcus