topic Re: How to export multiple sheet objects in single pdf? in QlikView

How to export multiple sheet objects in single pdf?

Mon, 28 Apr 2014 10:40:29 GMT

Hi Experts,

Can you please guide me if there is any way or workaround to export multiple sheet objects into single pdf file?

Thanks in advance.

Re: How to export multiple sheet objects in single pdf?

bbi_mba_76 — Mon, 28 Apr 2014 10:44:44 GMT

Hi,

maybe you could use this post to export all in an excel common Macro to export excel for 6 different objects and then you have to export the excel as pdf

Re: How to export multiple sheet objects in single pdf?

Mon, 28 Apr 2014 11:00:01 GMT

Thanks Michele.. I will try to implement this and let you know the results.

Re: How to export multiple sheet objects in single pdf?

Colin-Albert — Mon, 28 Apr 2014 11:06:26 GMT

You could add the objects to a report and then print the report to pdf.

Re: How to export multiple sheet objects in single pdf?

Mon, 28 Apr 2014 11:13:41 GMT

Hi you can create a report and then print the report in a macro.

regards,

Re: How to export multiple sheet objects in single pdf?

Colin-Albert — Mon, 28 Apr 2014 14:25:45 GMT

You do not need a macro to print a report - you can use an action for this.

Re: How to export multiple sheet objects in single pdf?

Tue, 29 Apr 2014 05:50:43 GMT

I know that you dont need a macro but in my case I had to save the pdf automatically into a specific folder and this you cant do with an action.

regards,

Re: How to export multiple sheet objects in single pdf?

Wed, 30 Apr 2014 08:55:08 GMT

Hi Colin,

Thanks for the solution.

I tried to add the objects to the report, but on a single page I can accomodate 3-4 objects only.

I need to loop the report for different customers. So, if I go on adding new pages then first the objects on first page will get repeated after that all the objects on second page will start lopping by customers.

Is there any way to accomodate all the objects( I need to add approximtely 10 objects) on a single page?

Thanks in advance

Re: How to export multiple sheet objects in single pdf?

Colin-Albert — Wed, 30 Apr 2014 15:47:40 GMT

You can set the report so either the whole report can loop through each value in a field, or you can set a page to loop through the values. ]

Look at the Report Settings - Banding and Page Settings - Banding

Re: How to export multiple sheet objects in single pdf?

Clever_Anjos — Wed, 30 Apr 2014 16:52:00 GMT

Use a report

Two helpful Reading

1) http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/06/using-qlikview-s-report-editor

2) http://community.qlik.com/docs/DOC-4709

Re: How to export multiple sheet objects in single pdf?

Thu, 01 May 2014 06:41:39 GMT

Thanks Anjos!!!

It worked for me.

Also the document explains clearly how to make maximum use of the Reports in Qlikview

Re: How to export multiple sheet objects in single pdf?

Thu, 01 May 2014 07:49:44 GMT

Take a look at a product called NPrinting from Vizubi, this allows you to pull objects from multiple dashboards into a single document. You can schedule and distribute the output with this too.

Re: How to export multiple sheet objects in single pdf?

Fri, 02 May 2014 13:01:54 GMT

Hi Clever Anjos,

The Demo shows when the user chooses the report, it opens a pop-up window and opens the report in PDF format.

But it tried to do the same, it shows pop-up window for a second or two, and after that there is no further action.

Can you please guide me if I am missing something.

Thanks in advance.

Re: How to export multiple sheet objects in single pdf?

Clever_Anjos — Fri, 02 May 2014 16:41:13 GMT

Is there any pop-up blocker active?

Which browser are you using?

Re: How to export multiple sheet objects in single pdf?

Mon, 05 May 2014 05:36:19 GMT

I am using IE8 as browser and there is no Pop-blocker active.

Re: How to export multiple sheet objects in single pdf?

Clever_Anjos — Mon, 05 May 2014 16:43:36 GMT

Could you post a screeenshot?