Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Send to Excel a table Numerical Field

Hello

i have this issue...

in some excel document when i do the "send to excel" option

it export a numerical field and the 0 of the left dissapears on excel 2007 (notepad include the 0 for verification)

but when i use the option export i choose the excel fomat then all the numbers of the field included the 0.

2 Replies
mwoolf
Honored Contributor II

Re: Send to Excel a table Numerical Field

Field is interpreted by Excel as a value, which loses the leading 0.

You may be able to format the field as text in Qlikview and have Excel interpret as text when sent to Excel.

Not applicable

Re: Send to Excel a table Numerical Field

Thanks

then when i do a selection export wirh the 0 ...

sometimes do it and sometime dont