Pulling Pivot table data in NPrinting Report

[vanand3535]

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?

[Chanty4u]

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]

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.

[Chanty4u]

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]

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?

[Chanty4u]

1. which version you are using qliksense?

you will get the option to export to excel.

2. you cant do direct pivot table.

[vanand3535]

ok,thanks