NPrinting Pivot table issue

[sikander02]

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.

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"

Thank you in advance.

[Ruggero_Piccoli · Accepted solution]

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.

[sikander02]

Awesome!! thank you very much Ruggero!!