NPrinting Pivot table issue

sikander02 — Wed, 25 Sep 2019 18:40:54 GMT

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.

Re: NPrinting Pivot table issue

Ruggero_Piccoli — Mon, 22 Oct 2018 09:05:27 GMT

Hi,

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

Do the following:

Click the Options dropdown menu under the PivotTable Tools - Analyze tab.
Select the Data tab.
Select the Refresh data when opening the file check box.
Set Number of items to retain per field to None.
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.

Re: NPrinting Pivot table issue

sikander02 — Mon, 22 Oct 2018 14:11:11 GMT

Awesome!! thank you very much Ruggero!!

topic NPrinting Pivot table issue in Qlik NPrinting

NPrinting Pivot table issue

Re: NPrinting Pivot table issue

Re: NPrinting Pivot table issue