Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Fareeha123
Contributor III
Contributor III

Create Multi Page Table in Nprinting

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. 

Labels (2)
11 Replies
David_Friend
Support
Support

@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...

Fareeha123
Contributor III
Contributor III
Author

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 

 

David_Friend
Support
Support

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-repo...

 

Fareeha123
Contributor III
Contributor III
Author

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?

 

Frank_S
Support
Support

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

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
WaelTaha
Contributor
Contributor

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?

Frank_S
Support
Support

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

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.