Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

'Send to Excel' loses leading 0's

Hi,

I have a chart in dashboard, which contains some values with leading 0's. When 'Send to Excel', the leading 0's disappear in Excel.

Does anyone have the same experience and know how to resolve this?

4 Replies
sunny_talwar

May be try the expression =Text([Ship to Customer ID])

SreeniJD
Specialist
Specialist

In general Qlikview will takes the first loaded value datatype as a default..

lets see the below scenario..

LOAD * INLINE [

    Year, CustID

    2015, 0123

    2014, 123

];

QV loads the data as below..

Year CustID

2015     0123

2014     0123

so, can you please check whether the first loaded column is having zero as prefix in Ship to CustomerID.. if not thats why the column is not treating as string..

Not applicable
Author

Hi Jd,

as you can see from the screenshot of the chart, leading 0's are displayed fine in QVW, only  disappear when sent to excel,  somehow the format is lost.

SreeniJD
Specialist
Specialist

Hi Vivien,

can you please provide me sameple data, it might be helpful to provide some quick solution.. as per the image, I have loaded data for those two columns only and i'm getting desired results even after exporting to excel..

871305.JPG