Building pivot table filters in nprinting

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for Search instead for Did you mean:

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for Search instead for Did you mean: Announcements Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for Search instead for Did you mean:

Not applicable ‎2017-10-18 07:13 AM how to show pivot table in nprinting excel report

In Nprinting excel how to create pivot table , while fetching pivot table object from Qliksense not shown in Nprinting table objects. meantime I want create pivot table in Nprinting report. usually drag n drop columns in exel sheet . I used insert pivot table from insert menu in excel . is it right format

7,297 Views

Ruggero_Piccoli

‎2017-10-18 10:00 AM

Qlik NPrinting supports Excel pivot tables. You can create them in your reports in the following two ways:

In both cases you must start from a QlikView or a Qlik Sense straight table. If you have a pivot table you can clone it and convert the clone into a straight. Then refresh the metadata and use the new clone.

If you add a Qlik Sense or QlikView pivot table in the Tables node you will nod see the single columns. So you cannot drag and drop each column manually.

As alternative you can add the original pivot as Images.

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 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.