topic Re: Generate a PDF report with multiple pages in Qlik Automate

Generate a PDF report with multiple pages

Babitharaju2014_ — Mon, 20 Nov 2023 07:19:07 GMT

Hi All,

I have below query, could you please help me to build an automation.

Generate a PDF report with multiple pages (which should loop over selections in a field / loop over possible values of a field based on selection from another field). Each page in pdf should contain chart of a sheet related to selection.

For example , I am having Factories and in one sheet 3-4 charts.

So while building automation if I select 3 factories, automation should generate 3 pages pdf which have data of each factory in each page.

Thanks,

Babitha

Re: Generate a PDF report with multiple pages

Vinay_B — Fri, 24 Nov 2023 15:28:13 GMT

Hi @Babitharaju2014_

You can generate multipage reports and store them in online storage such as SharePoint. The steps are listed below:

https://community.qlik.com/t5/Official-Support-Articles/How-to-create-multi-app-reports-and-store-them-to-Microsoft/ta-p/1993814

https://community.qlik.com/t5/Official-Support-Articles/How-to-create-multi-page-PowerPoint-report-and-store-them-to/ta-p/2025290

You can then include the link in the mail block, teams, or slack to share them with the end users. It is not possible to add them to the mail block directly.

Re: Generate a PDF report with multiple pages

Babitharaju2014_ — Wed, 13 Dec 2023 09:37:52 GMT

Hi All,

Thanks for the reply.

How to loop over a selection in a field and generate pdf report each page for each selection. For example If I have a column country and I have sheet named Sales. If I select 3 countries , Automation should loop over those 3 countries and create 3 page pdf with each page containing data for each country. Is that possible through automation ? Because that type of feasibility was there in Qlikview while developing pdf reports(loop over selections). Kindly guide me on which block will help here.

Thanks,

Babitha