Workaround for 200 page per PDF print limit in Qlik Reporting

saurabh_Qlik1 — Wed, 28 Feb 2024 09:11:57 GMT

I have a Qlik Sense app containing financial data for 500 entities (the number of entities can vary).

There are 2 sheets in the App containing charts and tables for one entity at a time with entity selection being done via a table placed on top of the sheet.

I am looking for a way to loop through all the 500 entities and print 2 sheets for each of the entity into one single PDF file. The resulting PDF would contain 1000 pages.

I tried using Qlik Reporting via Application Automation (QAA) to achieve this but it has a limit of 200 pages per PDF.

Is there a way to print the PDFs in a batch of 200, i.e. generate 5 PDFs of 200 pages each which I can later combine manually?

Re: Workaround for 200 page per PDF print limit in Qlik Reporting

JonnyPoole — Wed, 28 Feb 2024 20:06:26 GMT

You can add a key into the data model that creates a different key value every 100 entities (100 x 2 pages each = 200) and then loop and filter on the key to produce as many 200 page reports as needed in QAA.

Another method is to try tabular reports which as of yesterday supports PDF format. You can add a 'page' (using Entity) to your excel template so that it paginates each entity. You put content for both sheets on 1 excel sheet and position it vertically so the content for the 2nd page is vertically lower than the content for the first page. I don't see a 200 page limit for tabular reports and I was able to create PDF with 800+ pages just now. There is a limit of 1000 images per report https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Reporting-service-specifications-limitations.htm#anchor-2

topic Workaround for 200 page per PDF print limit in Qlik Reporting in Reporting Service & Alerting

Workaround for 200 page per PDF print limit in Qlik Reporting

Re: Workaround for 200 page per PDF print limit in Qlik Reporting