topic how to show pivot table in nprinting excel report in Qlik NPrinting

how to show pivot table in nprinting excel report

Wed, 18 Oct 2017 11:13:02 GMT

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

Re: how to show pivot table in nprinting excel report

Ruggero_Piccoli — Wed, 18 Oct 2017 14:00:13 GMT

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.

Re: how to show pivot table in nprinting excel report

boopeshj — Tue, 04 Feb 2020 12:51:12 GMT

@Ruggero_Piccoli Do you know the technical challenge why we cannot import a Qlikview Pivot table into NPrinting ?

That would really help when we have a scenario where we change a dimension value from row to column 🙂 Do you have any alternatives ?

Re: how to show pivot table in nprinting excel report

Ruggero_Piccoli — Tue, 04 Feb 2020 13:10:04 GMT

Hi,

You can import QlikView Pivot Tables into Qlik NPrinting templates, they are supported. You cannot import QlikView Pivot Tables in all nodes of a template, for example Levels do not support QlikView Pivot Tables, but you can import them as images or tables.

Refer to this help site page https://help.qlik.com/en-US/nprinting/November2019/Content/NPrinting/ReportsDevelopment/Qlik-objects-supported-NP.htm

Maybe you mean that you don't see the columns of a QlikView Pivot Table when you add it in the Tables node but this is work as design. If you want to see the column you must convert the pivot into a straight table.

Best Regards,

Ruggero