topic Export to Excel conversion error in QlikView

Export to Excel conversion error

Tue, 01 Feb 2011 08:40:56 GMT

Hi guys,

I have the following table of values:

AGRINET PRODUCT CODE	PRODUCT DESCRIPTION (Eng)	CUSTOMER PRODUCT CODE
65010-10-02	POLYFILLA INT POLYCELL 2KGX8	124626
65010-10-02	POLYFILLA INT POLYCELL 2KGX8	D1178
65010-10-02	POLYFILLA INT POLYCELL 2KGX8	903630
65010-10-02	POLYFILLA INT POLYCELL 2KGX8	6001606010404

But when I export these to excel, the first column's value get changed to numbers, which is a big problem for me. I've tried fiddling around Qlikview & Excel to find a solution that will work, but to no avail.

What we would like to do is export the tables to excel & send them to our customers to keep them updated on our product codes etc.

The result I get when exporting to Excel is the following:

AGRINET PRODUCT CODE	PRODUCT DESCRIPTION (Eng)	CUSTOMER PRODUCT CODE	MIN ORDER QTY	DELETE FLAG	BARCODE
23050730	POLYFILLA INT POLYCELL 2KGX8	124626	0.00
23050730	POLYFILLA INT POLYCELL 2KGX8	D1178	0.00
23050730	POLYFILLA INT POLYCELL 2KGX8	903630	0.00
23050730	POLYFILLA INT POLYCELL 2KGX8	6001606010404	0.00

Any ideas would be highly appreciated. I`m sure I`m not the only one experiecing this when exporting mixed-type data to excel.

Export to Excel conversion error

marcohadiyanto — Tue, 01 Feb 2011 10:05:29 GMT

hi,

i think because of your agrinet product code same as date format in qlikview. so when you export them to excel, have your code had different value.

i'm still can't find the solution

Export to Excel conversion error

Tue, 01 Feb 2011 14:09:36 GMT

Hi Marco,

I definitely feel it has something to do with a date conversion of some sort, which is why I check my regional & language settings for the date format used.

Also, the start of my Qlikview script has the following:

SET

SET TimestampFormat='YYYY/MM/DD hh:mm:ss[.fff]';

Does anybody know how I can sidestep this conversion or know where I can override the manual settings?

Thanks in advance!

DateFormat='YYYY/MM/DD';

Export to Excel conversion error

Tue, 01 Feb 2011 15:57:58 GMT

Hi all,

For those interested, I've found the solution.

When loading the data into the model, explicitly define the field as text.

When this then gets exported to Excel, it will export as text & no conversions will be done on the data.

For example:

Load

....

TEXT(PRODUCT_CODE) as [AGRINET PRODUCT CODE],

.....

FROM ....;

Export to Excel conversion error

marcohadiyanto — Wed, 02 Feb 2011 04:17:52 GMT

hi,

it's nice solution.

Export to Excel conversion error

Thu, 24 Feb 2011 23:12:27 GMT

Thanks. Your solution worked for me.

Don Saluga

ServiceLink

Pittsburgh, Pa.