topic Re: Table box export to Excel problem in QlikView

Table box export to Excel problem

p_noindl — Mon, 06 Jul 2015 05:31:38 GMT

There seems to be a problem exporting a table box (placed inside a Container box) in webview to Excel - QV crashes. Anyone has an explanation for that problem?

Re: Table box export to Excel problem

Siva_Sankar — Mon, 06 Jul 2015 06:12:12 GMT

Peter,

It works fine for me.

What is the data volume you have?

Re: Table box export to Excel problem

p_noindl — Mon, 06 Jul 2015 06:14:07 GMT

Hi,

it is no matter of data volume, in the attached sample you see only 6 rows. And it happens only in web view!

Re: Table box export to Excel problem

jagan — Mon, 06 Jul 2015 06:17:58 GMT

Seems as a problem in Container, when the table box is defined outside the container it is working fine.

hic‌ mto‌ please look into this.

Regards,

Jagan.

Re: Table box export to Excel problem

shambhub — Mon, 06 Jul 2015 06:19:48 GMT

Hi Peter,

Turn off web view and remove print option and again turn on web view, now you can try.

Best regards

Shambhu B

Re: Table box export to Excel problem

svenkita — Mon, 06 Jul 2015 06:27:59 GMT

Turn off Web View

Right Click and send to Excel

Turn on the web view

and try...

It works fine.

Re: Table box export to Excel problem

jonathandienst — Mon, 06 Jul 2015 06:46:22 GMT

Its related somehow to the presence of the table TB01 on the sheet and in the container.

In normal desktop view, and look at Sheet Properties | Objects, you will see TB01 listed as an object (although it is not visible). I deleted that object and then switched back to webview. Then I exported the table to Excel without a problem.

The presence of the linked object should not be a problem, but perhaps that object was corrupted somehow.

Re: Table box export to Excel problem

p_noindl — Mon, 06 Jul 2015 07:07:33 GMT

you are right, it seems to be a bug with the container object

Re: Table box export to Excel problem

p_noindl — Mon, 06 Jul 2015 07:09:16 GMT

just open qv again and the same problem will appear

Re: Table box export to Excel problem

jonathandienst — Mon, 06 Jul 2015 07:52:06 GMT

Peter Noindl wrote:

just open qv again and the same problem will appear

Yup = the extra TB01 reference reappears spontaneously. Container bug (or corruption) most likely cause. You could try a no-data load which may get rid of the corruption the container - or it may be enough to delete TB01 in the table and from the container, delete the container and recreate the objects.

Re: Table box export to Excel problem

p_noindl — Mon, 06 Jul 2015 08:26:21 GMT

it is a bug, try it yourself and make a new qv document.