topic Last row of Pivot Table is not merging of second, third, forth of columns when applying Grand Total in Qlik N-Printing in Qlik NPrinting

Last row of Pivot Table is not merging of second, third, forth of columns when applying Grand Total in Qlik N-Printing

Dhirendra_Kharwar__13373 — Fri, 15 Nov 2024 21:48:40 GMT

Dear,

I am getting an issue when I'm trying to create a pivot table in Nprinting. The issue is that the last row of the second and third columns is not merging when applying Grand Total and then I am previewing the report in PDF format.

Qlik NPrinting ting May 2021 SR3

Version: 21.14.7.0

Column1	Column2	Column3	Column4	Measure1	Measure2
Row1	Row1	Row1	Row1	1	23
	Row1	Row2	Row2	2	23
	Row2	Row3	Row3	3	23
	Row2	Row4	Row4	4	23
Row2	Row3	Row5	Row5	5	23
	Row4	Row6	Row6	6	23
		Row7	Row7	7	23
		Row7	Row8	8	23
	Row5	Row8	Row9	9	23
		Row9	Row10	10	23
			Row11	11	23
Grand Total				66	253

The problem in the last row of 2ns,3rd, and so on columns is shown in the Image.

Please suggest me a solution for the same

Re: Last row of Pivot Table is not merging of second, third, forth of columns when applying Grand Total in Qlik N-Printing

Lech_Miszkiewicz — Fri, 17 Feb 2023 07:29:01 GMT

Ok - lets start from the beginning...

out of all supported and unsupported versions you listed in the label which is the one you actully use - is this the one you wrote in text? If yes - there is no point listing all the labels as they are creating confusion. Instead always use only the label of the version you use.
This does not look like a pivot table - it looks more like a report which is meant to "look like pivot table" but is made of probably levels and tables inside of the level
1. If that is the case then we would need to see how your template is built. I am guessing you could use "delete row" tag in some places to avoid getting borders passed from cells below - but again - hard to say without understanding what exactly is happening there.
screenshots of template withs steps on how to replicate your issue would be helpful (or if it is dummy app just attach Qlik Sense app and export report template so we can have working files to deal with)

cheers

Re: Last row of Pivot Table is not merging of second, third, forth of columns when applying Grand Total in Qlik N-Printing

Ruggero_Piccoli — Fri, 17 Feb 2023 09:30:27 GMT

Hi,

From May 2021 SR3 to latest available version (May 2022 SR3) we did many updates on how merged cells are managed. Refer to the Release Notes for the details.

In addition to @Lech_Miszkiewicz 's suggestions, you should update your installation and check if with latest version the issue still appears.

Best Regards,

Ruggero

Re: Last row of Pivot Table is not merging of second, third, forth of columns when applying Grand...

Frank_S — Fri, 17 Feb 2023 16:18:50 GMT

@Dhirendra_Kharwar__13373

If what you have shown is actually a pivot table (I agree with Lech that it does not look like a pivot table), you should check this most commonly missed steps when creating a Pivot table with QlikView or Qlik Sense data.

Also ensure the points that Ruggero made are followed accurately.

Kind regards...and see below:

https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm

Ensuring data is refreshed when report is opened

If you do not perform these steps, you will see an empty pivot table in the generated report.

Do the following:

Under the PivotTable Tools - Analyze tab. On the left, click the Options drop down menu .
Select the Data tab.
Click the Refresh data when opening the file check box.
Set Number of items to retain per field to None.

Click OK.