Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

NPrinting Pivot table issue

Hi ,

I am trying to make  a pivot table in NPrinting , Everything looks fine but the total value of a calculated field is not showing up unless I refresh the data after generating the report. Capture.PNG

Note: I have moved the Values from "Column Labels" to "Row Labels" that's when the problem started. It works fine if I keep the values in "Column Labels"

Capture.PNG

Thank you in advance.

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Hi,

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

Do the following:

  1. Click the Options dropdown menu under the PivotTable Tools - Analyze tab.
  2. Select the Data tab.
  3. Select the Refresh data when opening the file check box.
  4. Set Number of items to retain per field to None.
  5. Click OK at the bottom of the PivotTable Options dialog window.

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

In this way the pivot will be automatically refreshed when opening the report.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

2 Replies
Highlighted
Employee
Employee

Hi,

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

Do the following:

  1. Click the Options dropdown menu under the PivotTable Tools - Analyze tab.
  2. Select the Data tab.
  3. Select the Refresh data when opening the file check box.
  4. Set Number of items to retain per field to None.
  5. Click OK at the bottom of the PivotTable Options dialog window.

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

In this way the pivot will be automatically refreshed when opening the report.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

Highlighted
Contributor III
Contributor III

Awesome!! thank you very much Ruggero!!