topic Re: Create Multi Page Table in Nprinting in Qlik NPrinting

Create Multi Page Table in Nprinting

Fareeha123 — Wed, 04 Jun 2025 20:55:52 GMT

I have requirement to page break on table on multiple slides in Nprinting. Table should dynamically list the countries based on the selection/ parameters. I have created Straight table in Qliksense with Country as dimension and have 6 measures. I want to create page in Nprinting powerpoint with straight table, and it should create slides based upon the countries in the selection criteria.

Re: Create Multi Page Table in Nprinting

David_Friend — Thu, 05 Jun 2025 14:18:24 GMT

@Fareeha123 please use the tag showing what version of NPrinting you are using.

Take a look at:

https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/PowerPointReports/Page-Features.htm

Re: Create Multi Page Table in Nprinting

Fareeha123 — Thu, 05 Jun 2025 14:28:14 GMT

Hi David,

Qlik NPrinting February 2024 SR3

Version: 24.4.14.0

The page feauture is only possible if we have bucket that groups countries under it, each page will show countries in it. By adding Country dimension on the page is generating page/slide for each country. We want first page/slide to show may be 10-15 countries next remaining and so on. Is this something that could be achieved via page feature

Re: Create Multi Page Table in Nprinting

David_Friend — Thu, 05 Jun 2025 15:38:05 GMT

Hi @Fareeha123 you use the country as a dimension to create multiple Powerpoint slides, however the data will likely go 'off the page' if its too long for the slide, this is actually a Microsoft limitation 😞

Suggest you do this in PixelPerfect instead and output as a PDF instead:

https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/PixelPerfectReports/Create-report-level.htm

Re: Create Multi Page Table in Nprinting

Fareeha123 — Thu, 05 Jun 2025 16:28:35 GMT

Hi @David_Friend i think there is some confusion, We cannot use Country as dimension. When i add Country on Page it is generating separate page/slide for each country

e.g.

slide 1: France Measure 1, Measure 2, Measure 3

Slide 2: Germany Measure 1, Measure 2, Measure 3

Slide 3: UK Measure 1, Measure 2, Measure 3

What i want is to have a page break on countries in a table

Slide 1: 1-15 countries and Measure 1, Measure 2, Measure 3 in a table

Slide 2: 16-30 countries and Measure 1, Measure 2, Measure 3 in a table

and so on.

Can this be achieved via Page feature?

Re: Create Multi Page Table in Nprinting

David_Friend — Thu, 05 Jun 2025 20:05:35 GMT

it should be able to do this:

https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/PowerPointReports/Pages-individual.htm

Re: Create Multi Page Table in Nprinting

Frank_S — Fri, 06 Jun 2025 16:00:25 GMT

Also try to use the object filter feature in the NP designer.

Applying a filter to an object

Re: Create Multi Page Table in Nprinting

WaelTaha — Sun, 08 Jun 2025 09:18:30 GMT

Thanks David, I work with Fareeha.

What she meant is ability to create multi-slide straight table. A long table that needs to be sliced on 2 or more slides, not creating a slide based on a set of dimensions. Rather using the result set output after applying the filter and then rendering a paged table on multiple slides.

the challenge we face is inability to base NP page object on a chunking dimension that’s dynamically calculated, not created using load script.
any workaround for this issue?

Re: Create Multi Page Table in Nprinting

Frank_S — Mon, 09 Jun 2025 15:43:27 GMT

There is a limitation with Microsoft powerpoint that prevents table data from automatically extending to the next slide when it does not fit on the initial slide.

The best tool to perform this type of task would be the Pixel Perfect editor. Unfortunately, this designer does not export output to powerpoint but rather, to PDF.

Adding totals and subtotals to PixelPerfect reports | Qlik NPrinting Help

Re: Create Multi Page Table in Nprinting

Lech_Miszkiewicz — Tue, 10 Jun 2025 09:13:11 GMT

Hi @Fareeha123

I am on leave at the moment and will be back home in couple weeks time. Then i will be able to test and share my idea.

it is around generic dimension which you would need to load to your data model and use in page as well as in your table paging model.

It will not be elegant solution, but i think it will be possible.

thanks

Lech

Re: Create Multi Page Table in Nprinting

David_Friend — Fri, 13 Jun 2025 14:07:13 GMT

like Frank said, probably PixelPerfect is your best bet to accomplish this, Powerpoint is too limiting.

Re: Create Multi Page Table in Nprinting

Ruggero_Piccoli — Mon, 16 Jun 2025 09:15:51 GMT

Hi,

As per @Frank_S 's suggestion you can add the source table multiple times each one with a different object filter.

Otherwise you can evaluate to create a new support fields with value, for instance, 1 for rows 1-15, 2 for rows 16-30 etc and use that new field in the Pages node.

Another idea could be to set the Custom Rows property:

Explained in https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/PowerPointReports/Native-table.htm#anchor-2. You must manage it manually by adding the same table multiple times each one with a different rows range.

Best Regards,

Ruggero