Discussion board where members can get started with Qlik Sense.
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?
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.
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.
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
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?
1. which version you are using qliksense?
you will get the option to export to excel.
2. you cant do direct pivot table.