Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vanand3535
Contributor

Pulling Pivot table data in NPrinting Report

I have a pivot table in my Qlik sense App.

I want to pull the data from Pivot table of Qlik sense app to NPrinting report.

But when i'm trying to pull the data from pivot table it's not showing data in NPrinting report that i have created

So, is there any way so that i can pull the data of pivot table into NPrinting report?

6 Replies
sureshqv
Esteemed Contributor III

Re: Pulling Pivot table data in NPrinting Report

hi

you cannot pull pivot table into Nprinting.

you need to create  base sheet as a stright table in Qlik  then  you need to create create custom pivot table based on that  strightable.

vanand3535
Contributor

Re: Pulling Pivot table data in NPrinting Report

ok, let me test

because Yesterday i have created a pivot table in Qlik sense and i was trying to pull data from there into the nprinting report that was not working.

sureshqv
Esteemed Contributor III

Re: Pulling Pivot table data in NPrinting Report

it will not work . you need workaround like above i mentioned.

do following :

1 . create starightable 

2.export to excel

3. create one new template 

4. in that add the strightable columns

5.create a pivot table based on that data.

remove the base sheet data except columns

use this template as custom in Nprinting

vanand3535
Contributor

Re: Pulling Pivot table data in NPrinting Report

Hi,

Just now I have created a new sheet into the Qlik sense and added a table then when I was trying to export it I'm getting only option to export into the pdf, not in excel.

One more thing, shall I directly create a pivot table instead of creating a table first then after exporting that, and after that can I export that pivot table?

sureshqv
Esteemed Contributor III

Re: Pulling Pivot table data in NPrinting Report

1. which version you are using qliksense?

you will get the option to export to excel.

2. you cant do direct pivot table.

vanand3535
Contributor

Re: Pulling Pivot table data in NPrinting Report

ok,thanks

Community Browser