topic Re: How to export multiple reports in single excel sheet wise when all reports displayed in single qlikview sheet? in QlikView

How to export multiple reports in single excel sheet wise when all reports displayed in single qlikview sheet?

srinivas1921 — Wed, 23 Nov 2016 17:33:50 GMT

Hi All,

We are displaying multiple reports in single qlikview sheet using straight table. All reports names we are displayed in a multi box object at the top of this chart and when user select particular report from multi box then that report results will be displayed in the chart. So all reports results will be displayed in single sheet only. In our report there is huge data is there.

As per our requirement, how to export all reports in single excel with sheet wise separately.

Plaese provide the solution on this.

It is very urgent requirement........

Many thanks in advance for u r support......

Thanks......

Re: How to export multiple reports in single excel sheet wise when all reports displayed in single qlikview sheet?

Gysbert_Wassenaar — Wed, 23 Nov 2016 17:51:32 GMT

Perhaps this blog post can help: http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

Re: How to export multiple reports in single excel sheet wise when all reports displayed in single qlikview sheet?

srinivas1921 — Sun, 27 Nov 2016 16:30:26 GMT

Hi,

Thanks for u r quick response. But this macro doesn't work in my scenario. In my application, a reports are displayed within one sheet only. So using single sheet I'd, we can't export all reports within one excel using this macro.

Please suggest if any alternative solution on this....

Thanks.....

Re: How to export multiple reports in single excel sheet wise when all reports displayed in single qlikview sheet?

Gysbert_Wassenaar — Sun, 27 Nov 2016 17:47:51 GMT

The macro can export multiple Qlikview objects to one excel sheet. And the macro can also export multiple Qlikview objects to multiple excel sheets. What are you trying you to?

Re: How to export multiple reports in single excel sheet wise when all reports displayed in single qlikview sheet?

srinivas1921 — Mon, 28 Nov 2016 02:43:03 GMT

But I am displaying a reports in single sheet then using single sheet I'd multiple times in the macro, can we export all reports at at a time?

Re: How to export multiple reports in single excel sheet wise when all reports displayed in single qlikview sheet?

Gysbert_Wassenaar — Mon, 28 Nov 2016 12:58:39 GMT

Are you talking about exporting Qlikview chart objects or Qlikview report objects, the kind you create with the Report Editor (started from the Reports menu)?

Re: How to export multiple reports in single excel sheet wise when all reports displayed in single qlikview sheet?

srinivas1921 — Mon, 28 Nov 2016 17:50:34 GMT

Hi,

I am talking about exporting qlikview chart objects only. But I already tried using macro which you have posted. That macro has given results that exporting 1st report only in every sheet in the excel due to straight table displayed 1st report while exporting into excel. So every sheet within the excel displayed that 1st report only but not other reports as well.

Please elaborate more u r solution on this.

Thanks for u r quick response on this. It is greatful if u r provide any example related to my scenario.

Thanks lot guysbert........

Re: How to export multiple reports in single excel sheet wise when all reports displayed in single qlikview sheet?

Gysbert_Wassenaar — Tue, 29 Nov 2016 07:35:48 GMT

You just have to fill the array correctly. See Sample 2 and 3. You can put any combination of qlikview chart objects on any sheet you want.