Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Contributor II

Data export


When I am exporting my data to excel 2007 I am having issue with Customer ID field.

Its a nine digit field usally starting with '0' i.e. 079829909

Once I export it to excel its not preserving the leading zero i.e 79829909.

Usally to over come this I convert the field to Text so that it holds the leading zero.

Please advise the best option to avoid such scenarios while exporting data.



2 Replies

Re: Data export

If you really need it to be text in excel then you'll have to convert it to text. Otherwise you could simply change the formatting in excel so it shows leading zeros.

talk is cheap, supply exceeds demand
Contributor II

Re: Data export


Community Browser