topic Re: NPrinting excel error - The row index should not be inside the pivottable report in Qlik NPrinting

NPrinting excel error - The row index should not be inside the pivottable report

afbraga1 — Thu, 26 Dec 2019 13:34:25 GMT

Hello,

When trying to generate an excel report with contains excel pivot tables I get the following error:

"ERROR: The row index should not be inside the pivottable report"

I believe the issue is with the 2 pivot tables to the right (image below), but I don't know what is the issue. The pivot tables will grow to the right where there is nothing and never touch each other. Any idea why this happens? I haven't found anything about this error so far.

Best regards,

André Braga

Re: NPrinting excel error - The row index should not be inside the pivottable report

Ruggero_Piccoli — Fri, 27 Dec 2019 10:34:44 GMT

Hi,

What are tags on the C column? Are they columns? If yes, did you hide the headers?

Are tags on the G column pivot tables in the source connection? If yes why are you using pivot tables with fixed titles on the left?

I suggest you to place each single tag on a cleat template so you can see their behaviour and understand what is overlapping. Then remember to hide the headers and in case test the Expand rows option.

Best Regards,

Ruggero

Re: NPrinting excel error - The row index should not be inside the pivottable report

afbraga1 — Sun, 29 Dec 2019 11:15:27 GMT

Hello Ruggero,

Thanks for your answer.

Columns B and C have respectively header and values for straight table objects I have imported from Qlikview.

Yes, Column G are in the source connection.

The reason I did it this way was because I felt that importing pivot tables from Qlikview with keep source formats or transforming a straight table to pivot table in excel was very unreliable on the column width. Sometimes it is far too wide or too narrow with no apparent reason that I was able discern. And since it was a requirement for what I'm doing, I'm trying to make it more reliable as possible.

I don't know if there is anything else that I might not be aware and that can help on this issue. What I am talking about can be seen on images below. Two excel sheets that are the result of cycling through a Page field. In both pages the width of columns H and I is far too different and I don't see a reason. It also resizes in excel to the correct width when I double click on the column width.

I did redo it on a clean template and the overlapping issue is now fixed, but I'm not too confident on why since I did not visually notice any objects overlapping. Still I'm taking your comments in consideration as I develop. Thank you.

Best Regards,

André Braga

Re: NPrinting excel error - The row index should not be inside the pivottable report

Aditya_Chitale — Mon, 10 Oct 2022 16:06:50 GMT

In my case the issue resolved after selecting the rows in which the pivot table was placed and selecting the clear formats option.

Regards,

Aditya