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.
