topic Re: Splitting rows between sheets in Qlik NPrinting

Splitting rows between sheets

shatings — Thu, 22 Apr 2021 13:21:10 GMT

Hello,

I have a report template I'm building in Nprinting with imported fields from QlikView. One field can sometimes have up to 100 or so rows, but for formatting purposes of the report I'm building, we can only include 35 rows of data per sheet in Excel. Is there a way to set this up? I don't think the add page function will work here, as it will spilt up each row of data. I need it to split up every 35 rows of data. Thank you!

Re: Splitting rows between sheets

Ruggero_Piccoli — Thu, 22 Apr 2021 13:58:14 GMT

Hi,

When posting a new question please remember to select the correct label with the version of Qlik NPrinting you are using, thanks.

There is not a native feature to split data on a new worksheet every certain number of rows. You could create a new field in your QlikView reload script with a new integer value every 35 rows than you will add that field in the Pages node. Because to create a new worksheet for every distinct value of a field you must use Pages. Instead if you want to create a different workbook (a different Excel file) you have to create a cycle.

Best Regards,

Ruggero

Re: Splitting rows between sheets

shatings — Thu, 22 Apr 2021 14:18:52 GMT

Thanks for the reminder and the potential work around!