Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
riyazasma1009
Creator
Creator
‎2019-11-15 05:28 AM

Adding a pivot table from QlikSense App into NPrinting

Hi Team,

I am using QlikSense Nov 2018 version. There is a pivot table in my QlikSense App which I have to use in NPrinting for building excel reports. I have read in different posts that the only way to create a pivot table in NPrinting is to create it from the QlikSense straight table. Is it not possible to create it from the pivot table directly.

Thanks,

Asma

Labels (1)
Labels
873 Views
0 Likes
2 Replies
Frank_S
Support
Support
‎2019-11-15 04:08 PM

Yes you can use your QS pivot table in your NPrinting excel report.

You can also create your own pivot table from QS data following the instructions below. (don't worry that it shows QV data...the development process is the same for QV and QS).

Kind regards...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
846 Views
0 Likes
Ruggero_Piccoli
Support
Support
‎2019-11-18 08:52 AM

Hi,

You can:

- import the Qlik Sense pivot in the tables node and drag and drop it in the template. Qlik NPrinting will expand it.

- import the Qlik Sense pivot in the images node. It will be rendered as image

- you can create a source straight table and follow one of the tutorial linked by @Frank_S . I suggest to avoid to use Levels because they slow down the report generation time. Using Excel native tables is faster. 

Best Regards,

Ruggero



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
807 Views
0 Likes