topic Re: Export to Excel does not show values in QlikView

Export to Excel does not show values

nenadvukovic — Wed, 13 May 2020 09:59:58 GMT

Greetings,

Recently we have upgraded to QV April 2020 and have noticed that values exported into Excel are not visible or they are rounded. Has anybody experienced that and what was the solution? Thanks

Measurement format:

QV Table:

Export to Excel:

1. No value visible

2. Values rounded

Re: Export to Excel does not show values

fosuzuki — Wed, 13 May 2020 09:25:09 GMT

Hi,

it should follow the formatting from the table in the qvw. What is the formatting option in the table?

Re: Export to Excel does not show values

nenadvukovic — Wed, 13 May 2020 09:56:29 GMT

Hi,

I've provided the formatting part in QV in my initial post.

Also, note that this was working perfectly before the QV upgrade. We were for 6 years on 11.20 SR12 and, unfortunately, had to upgrade because of the Windows Server version.

Re: Export to Excel does not show values

fosuzuki — Wed, 13 May 2020 12:01:03 GMT

The formatting option you posted was from the Document Properties panel, right?

What is the source object you are exporting from? A straight table?

Re: Export to Excel does not show values

nenadvukovic — Wed, 13 May 2020 12:19:33 GMT

Yes.

The source table is a Table Box type of table.

Could that be a reason? I usually do not use plan tables but this is one of the very old apps developed by someone else.

Thanks

Re: Export to Excel does not show values

Or — Wed, 13 May 2020 12:53:08 GMT

Qlik entirely changed the way numeric exports work in April 2020 (it's listed under "bug fixes" in the release notes, oddly enough). It seems one of these changes may have broken the exporting of any values formatted as Number (X Precision), which will always be exported as an integer (format is e.g. #,### for precision 4). You can work around this to some extent, by using a fixed to / X decimals, which does export correctly.

I would have to call this a bug - it's clearly not exported as it should be. Qlik seems to be reading #### as "Up to four digits, before or after the decimal separator", while Excel reads it as "Up to four digits, before the decimal separator".

Re: Export to Excel does not show values

nenadvukovic — Wed, 13 May 2020 13:31:40 GMT

Fully agree this is a bug, as it worked just normal in previous versions. I've asked our account manager to report it to Qlik. Thanks