Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

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

1 Reply
Employee
Employee

Re: how to show pivot table in nprinting excel report

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

- Creating an Excel pivot table report using levels ‒ Qlik NPrinting

- Creating pivot table using Excel table columns ‒ Qlik NPrinting

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.

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