Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
IMPORTANT: PLEASE READ - Labels will be required in the NPrinting forum starting on Friday September 26, 2019: Click here for details and instructions.
Highlighted
sikander02
New 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
Employee
Employee

Re: NPrinting Pivot table issue

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.
2 Replies
Employee
Employee

Re: NPrinting Pivot table issue

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.
sikander02
New Contributor III

Re: NPrinting Pivot table issue

Awesome!! thank you very much Ruggero!!