topic Re: In Excel formatting is there another way to separate in pages besides the left menu? in Qlik NPrinting

In Excel formatting is there another way to separate in pages besides the left menu?

julioarriaga — Thu, 17 Jun 2021 15:54:00 GMT

I just want to know if the only way to divide a report in pages in Excel is through the Page division? (see image)

Are there any other alternatives?

Thanks as always.

Kind regards

Re: In Excel formatting is there another way to separate in pages besides the left menu?

Frank_S — Thu, 17 Jun 2021 16:14:39 GMT

@julioarriaga

Can you describe in detail exactly what your requirement is?

The page feature allow you to create a new excel tab for each dimension value.

What exactly are you needing?

Perhaps create a workbook for each dimension value (if so , you cycle feature - https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Cycling-your-reports.htm)
Or create a document base on an NP user filter (dimension value assigned to a specific user - see https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Recipients&Users/Create-users-filters-groups.htm#anchor-7

kind regards...

Re: In Excel formatting is there another way to separate in pages besides the left menu?

RajaDumpa — Fri, 24 Sep 2021 19:55:48 GMT

Hi Frank, The above issue Julio is referring as to how to properly split the Table Header to repeat for each page without being duplicated as seen below, in the PDF output via an Excel template. See the below image where the Table header repeats twice even after setting the Rows to Repeat, It doesn't fit to the page properly.

Could you advice if we can make the Table header repeat only once per PDF Page ?

Re: In Excel formatting is there another way to separate in pages besides the left menu?

Frank_S — Fri, 24 Sep 2021 20:50:22 GMT

Hi @RajaDumpa

To do that I suggest using PixelPerfect (PxP) report rather than excel given that you are exporting a PDF. It is more effective to do it from PxP. I personally never succeeded in adding PDF page breaks in an Excel report. Perhaps someone else here with greater MS Excel skills than I can help you with that.

In any case again I suggest using PxP report and follow the solution that I provided there.

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-space-at-least-the-table-header-with-one-row-on-the-same/m-p/1834738#M33310

Kind regards...