topic Re: NPrinting separate PDFs for each Excel sheet in Qlik NPrinting

NPrinting separate PDFs for each Excel sheet

Anonymous — Fri, 16 Dec 2016 18:58:29 GMT

Is there a way to create a separate PDF for each Excel sheet in a report? I've used Pages to create multiple Excel sheets, but when I run the report, I'd like to create a different PDF document for each sheet. I'm using NPrinting 17.2.1 linked to Qlik Sense.

Re: NPrinting separate PDFs for each Excel sheet

Tue, 20 Dec 2016 18:22:49 GMT

Currently this isn't possible in NPrinting 17.

Re: NPrinting separate PDFs for each Excel sheet

neelamsaroha157 — Tue, 20 Dec 2016 19:27:26 GMT

Hi,

I am not sure about NPrinting 17 but I am using version 16 and while creating a task it gives an option how you want to distribute the report.

Here is the screenshot if it helps

Re: NPrinting separate PDFs for each Excel sheet

Anonymous — Wed, 21 Dec 2016 14:50:14 GMT

Hi Neelam,

Thank you for your reply! Most of these same options are available in version 17. Unfortunately they don't distinguish between sheets. So the xlsx option will publish a single Excel report with all sheets in the same document, and the pdf option will pdf all sheets into a single pdf report. But I would like to have a pdf report for EACH sheet in my Excel template. So if I have 3 sheets in my template, there should be 3 pdf reports generated.

Re: NPrinting separate PDFs for each Excel sheet

Wed, 21 Dec 2016 15:30:42 GMT

It's a gap feature from NPrinting 16 called Cycles. Not available in NPrinting 17.

Re: NPrinting separate PDFs for each Excel sheet

Anonymous — Wed, 21 Dec 2016 15:33:30 GMT

So does that mean that it's possible to create separate reports by Excel sheets in NPrinting 16, but not in NPrinting 17?

Re: NPrinting separate PDFs for each Excel sheet

Wed, 21 Dec 2016 15:54:17 GMT

Correct.

As you noted in NPrinting 17 you can create a sheet, page, section, slide... for every value of a dimension, but not a separate file.

What's the use case if I can ask?

Re: NPrinting separate PDFs for each Excel sheet

mkelemen — Wed, 21 Dec 2016 16:30:15 GMT

If you have small and fixed number of sheets you can work around it by using recipients.

Each recipient will have its filter with one of values which are used in pages.

Scenario 2 in this document: Cycling in NPrinting 16 vs. Bursting in NPrinting 17

BR,

Matus

Re: NPrinting separate PDFs for each Excel sheet

Anonymous — Wed, 21 Dec 2016 16:46:49 GMT

I've used the Pages option to create sheets within Excel based on an imported field from Qlik Sense. This field is variable in the sense that it won't have a fixed number of values. I'd like to create each sheet as a separate pdf and export to a folder so I can distribute these to the various users of the reports.

Ultimately, I have a 1:1 relationship between recipients and Excel sheets, but there are ~10,000 recipients, so adding these recipients to NPrinting, then creating and assigning filters isn't feasible. The variability of the field also complicates managing this through filters.

Re: NPrinting separate PDFs for each Excel sheet

Anonymous — Wed, 21 Dec 2016 16:55:35 GMT

Hi Matus,

This is a really interesting article! I'm unfortunately looking at both a variable number of sheets and a very large number (~10,000). Scenario 2: Receive separate reports for each country - save to disk is a fascinating work around, particularly when paired with a group import of users and filters.

Although the solution presented in this article partially solves my problem, it's by no means an elegant solution due to the quantity of users needed to execute the task.

There's mention of the Cycling feature being introduced in NPrinting 17 sometime in 2017, has anyone heard of when this might occur?

Re: NPrinting separate PDFs for each Excel sheet

mkelemen — Wed, 21 Dec 2016 17:56:00 GMT

If you are sending those pdfs out then this is the best scenario - you can send emails instead of saving to disk. If you are just saving to a directory then cycling will save you the trouble with maintaining recipients.

I guess those who know about the features are under NDA.

Re: NPrinting separate PDFs for each Excel sheet

vbeachii — Tue, 26 Nov 2019 20:14:19 GMT

Any updates to being able to create a PDF for each tab in an excel file? The last post here was from 2016.

Re: NPrinting separate PDFs for each Excel sheet

Frank_S — Tue, 26 Nov 2019 21:03:53 GMT

1. Within your NPrinting report, decide which dimension value you wish to use for each tab, right click on 'page' and select the dimension that you wish to use

2. You will notice that the dimension tag now appears in your excel sheet

3. Preview your report.

The output may generate several pages of PDF output based on your data

Re: NPrinting separate PDFs for each Excel sheet

Frank_S — Tue, 26 Nov 2019 23:07:55 GMT

Btw,

if you want a separate PDF per dimension value, use the 'cycle' feature.

In this case I also cycled for 'Year and got 3 PDFs. One for each year.

Re: NPrinting separate PDFs for each Excel sheet

vbeachii — Sun, 01 Dec 2019 01:15:25 GMT

Thanks, I need to cycle and create a PDF for each Provider ~1,300 for each specialty. Or at least I was going to try. I have now decided to go a different route, but thanks for helping to update this question. Much appreciated!