topic NPrinting Pivot Table in Qlik NPrinting

NPrinting Pivot Table

Pomna — Mon, 09 Nov 2020 22:41:07 GMT

I need to create a pivot table in NPrinting but am having issues with a dimension not showing all the values. The report was imported to NPrinting in straight table format. But am getting issues achieving this because the quarter dimension only shows one value. It does not show all four quarters. Thanks for your suggestions

Re: NPrinting Pivot Table

Lech_Miszkiewicz — Tue, 10 Nov 2020 02:08:20 GMT

Hi @Pomna

as usual - to get an answer or hint what could be wrong you should provide us with screenshot of your source data, template, results and mock-up of what you are trying to achieve. We are not there with you and cannot see what you are doing wrong.

Topic you are describing seems quite basic so I assume there is either something not supported breaking it or simple mistake when creating template.

Re: NPrinting Pivot Table

Pomna — Wed, 11 Nov 2020 17:08:03 GMT

Below is a screen shot of what I expect my pivot table to look like and what I get. The quarter dimension loses all its values. I expect to see Q1, Q2, Q3 and Q4.

Re: NPrinting Pivot Table

Lech_Miszkiewicz — Thu, 12 Nov 2020 04:56:04 GMT

Ok - you have only shown me a pivot table. Obviously to built pivot table you first need to produce a straight table with the data.

Is your straight table populated properly?
Are you using range or named table to populate data for your pivot table?
- I am suggesting using named table as per this link and official documentation: https://help.qlik.com/en-US/nprinting/September2020/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm
Have you tried to refresh data in Excel Pivot table?
- Right click on pivot table ---> Refresh

Re: NPrinting Pivot Table

Pomna — Fri, 13 Nov 2020 22:50:07 GMT

Thank you the link you provided was of great help but I ran in to other issues. Calculated columns are giving me the #DIV/0! Error message.

Column 3 is column 2/ column 1

Column 6 is column 5/ column 4

Column 8 is column 7/ column 6

Any suggestions on how to fix this?

Re: NPrinting Pivot Table

Lech_Miszkiewicz — Sat, 14 Nov 2020 08:30:22 GMT

Hi,

The #DIV/0! error is typical excel error when you try to divide by 0. There is nothing more to add to it.

I repeat again - to give you meaningful information we need to see full picture of all steps you are doing. You are not providing those steps to us so our answer is only based on what we can see.

Side note:

Based on your screenshots I can see 1 strange thing:

why there are "=" signs in your dimension fields? Why your table in Qlik Sense contains those dimensions with = sign which makes them automatically calculated dimensions! I would correct that to start with as it has implications on how NPrinting handles objects with calculated dimensions. (it is good practice to get rid of them if they are not necessary)