Discussion Board for collaboration on QlikView Scripting.
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.
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.