topic Re: Exporting objects in Containers in QlikView

Exporting objects in Containers

sangland2 — Thu, 24 Mar 2016 03:50:56 GMT

Hi, I have 2 charts and one table which I can export to Excel using a Macro from a button. When move them to a container and remove them from outside the container then I get an error from the macro. After some testing I have concluded than only 1 chart inside a container can be accessed by a Macro (does't matter which one). Does this make any sense? I can add tables to the container and these can be accessed by the macro.

Re: Exporting objects in Containers

jagan — Thu, 24 Mar 2016 04:10:37 GMT

Hi,

Check this links

How to use macros to export objects into excel

Re: Export multiple Container into Excel

Export chart from container by macro

Regards,

Jagan.

Re: Exporting objects in Containers

tamilarasu — Thu, 24 Mar 2016 04:15:40 GMT

Hi Simon

I too faced this situation once and found a solution. Hope the below attachment helps you.

Go to macro window and update the below part as per your requirement..

If you have any issues, let me know.

Update: I just removed some lines of code (as I found not necessary) and attached a new application.

Re: Exporting objects in Containers

Chanty4u — Thu, 24 Mar 2016 05:46:24 GMT

Nice raj

Re: Exporting objects in Containers

sangland2 — Thu, 24 Mar 2016 06:38:37 GMT

Much appreciated.