Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sriabt
Contributor
Contributor

Nprinting report - How to split the records in multiple sheets in same report?

In Nprinting report, can you help

- How to split(by 45000 rows) the Qliksense pivot table or table records generate in to multiple sheets in same excel report in Nprinting?

- How to split(by 60000 rows) the Qliksense pivot table or table records generate in to multiple sheets in seperate excel files in Nprinting?

Qlik NPrinting 

Labels (3)
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

I suggest you post Qlik NPrinting questions in the related community https://community.qlik.com/t5/Qlik-NPrinting-Discussions/bd-p/qlik-nprinting-discussions

To create a separate worksheet on the same Excel workbook you can add a field in the Pages node. This will create a different worksheet for each distinct value of the added field. Here there is the explanation for PowerPoint https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/PowerPointReports/Pages-individual.h... and in Excel, it is the same.

To split generated reports into different files you have to use cycles that are explained in details at https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Cycling-your-repo...

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

1 Reply
Ruggero_Piccoli
Support
Support

Hi,

I suggest you post Qlik NPrinting questions in the related community https://community.qlik.com/t5/Qlik-NPrinting-Discussions/bd-p/qlik-nprinting-discussions

To create a separate worksheet on the same Excel workbook you can add a field in the Pages node. This will create a different worksheet for each distinct value of the added field. Here there is the explanation for PowerPoint https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/PowerPointReports/Pages-individual.h... and in Excel, it is the same.

To split generated reports into different files you have to use cycles that are explained in details at https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Cycling-your-repo...

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.