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?
May be try the expression =Text([Ship to Customer ID])
In general Qlikview will takes the first loaded value datatype as a default..
lets see the below scenario..
LOAD * INLINE [
QV loads the data as below..
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..
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.
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..