Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense pivot table as image in NPrinting

I have a pivot table in Qlik Sense.  It has 90 rows (to show the $ past due for every day in the past 90 days).

When I bring it into NPrinting (Qlik NPrinting February 2018 SR1) as an image, the pivot table gets cut off after about 18 rows.

Am I missing something obvious?  How do I display the entire Qlik Sense pivot table in NPrinting?  I know NPrinting doesn't (yet) support bringing in Qlik Sense pivot tables, which is why I'm bringing it in as an image, and I would like to avoid having to bring in the source data as a table and having to rebuild it as a pivot table in NPrinting.

Thanks.

1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Jorn,

Sorry mate - You are not missing anything - this is actually normal and expected behavior.

If your Pivot Table is too big and you still want it in your report you have no choice but

  • converting it to straight table and using Excel Template and Pivot Table functionality from Excel
  • converting it to straight table (in case when columns in Pivot table are always the same) and using straight table workaround:

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

1 Reply
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Jorn,

Sorry mate - You are not missing anything - this is actually normal and expected behavior.

If your Pivot Table is too big and you still want it in your report you have no choice but

  • converting it to straight table and using Excel Template and Pivot Table functionality from Excel
  • converting it to straight table (in case when columns in Pivot table are always the same) and using straight table workaround:

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.