topic Re: Creating an Excel Pivot Table from a Qlik Sense Table in Qlik NPrinting

Creating an Excel Pivot Table from a Qlik Sense Table

Anonymous — Tue, 03 Oct 2017 15:14:32 GMT

Hello everyone,

I am struggling with creating a Qlik NPrinting June 2017 Excel template pivot table from a straight table in qlik sense. Since NPrinting does not support pivot tables, I am attempting to go this route. Does anyone have some steps to accomplish this correctly?

Thanks

Re: Creating an Excel Pivot Table from a Qlik Sense Table

devarasu07 — Tue, 03 Oct 2017 15:19:01 GMT

Hi,

refer this article

How to Create an Excel PivotTable Report

below thread i've shared my working file. try create levels in Nprinting excel report.

Repeat Column header in Qlik Nprint 16.3

Re: Creating an Excel Pivot Table from a Qlik Sense Table

Anonymous — Tue, 03 Oct 2017 15:22:33 GMT

Thank you,

I cannot seem to add my straight qlik sense table as a level? Any thoughts? The object ID appears in tables but not in levels.

Thanks,

Russell Glenn

Re: Creating an Excel Pivot Table from a Qlik Sense Table

devarasu07 — Tue, 03 Oct 2017 16:04:06 GMT

Hi,

in qliksense? are u trying to import extension into nrpinting? or default table? afaik in build table should work. i've attached qlikview sample try the same way in qliksense.