Pivot Table can be only exported as an Image from QlikSense.
As an alternative you can export data to Excel using straight table from QlikSense and doing Pivoting in Excel.
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.
But I want to automate the whole export job using NPrinting as there are multiple pivot tables in my App also i don't want to change the table structure in Qlik Sense from pivot to straight (as some of the tables are Trend tables and i have to create multiple metrics to serve the purpose in straight table.). Any solutive thought over this ?
Qlik Sense pivot tables are not supported in the Qlik NPrinting templates report Tables node. At the moment the only two workarounds are:
- insert them in the Images node, so export them as images
- transform them into straight tables (in the same app or in a new one cloned to be used as Qlik NPrinting source) and re-create the pivot in the Excel report template
I'm sorry but unfortunately, at the moment, there are no other solutions to export Qlik Sense pivot tables.
QlikView pivot tables are supported.