Skip to main content

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
jlongoria
Creator
Creator

Qlik Sense Pivot Table not displaying correctly in PowerPoint

I am referencing a pivot table in a Qlik Sense app as an image from an NPrinting PowerPoint report.

Below is an image of what the pivot table looks like in Qlik Sense.

PivotTableSense.jpg

Below is an image of how the image is rendering in PowerPoint. I have NOT found a way to make it so that the data is expanded. What am I missing???

PivotTablePPT.jpg

Labels (2)
5 Replies
Frank_S
Support
Support

Hi @jlongoria

 

Thank you for provided this level of clear detail about the issue. As such:

  • I have tested and received the same result despite having it fully expanded in the Qlik Sense app as shown in the 2nd image below:
  • Keep in mind that even if you could fully expand the rows, if you have too many rows that go off the sheet in any Qlik Sense chart used in a Powerpoint exported report, those rows will not expand to the next PPTX slide.

Wish I could give you better news on this. However others here may have suggestions for you beyond what I have shared.

Collapsed report output in NP PPTX report

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Digvijay_Singh

How does it render if you add it to the tables node?

Digvijay_Singh

You may try below properties to configure data resolution, means to show more content in a given space. Probably it would show pivot expanded if enough space is available, not sure though.

Digvijay_Singh_0-1646337324632.png

 

Frank_S
Support
Support

@Digvijay_Singh

Tested both...similar result

 

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Frank_S
Support
Support

@jlongoria

 

I wanted to share a possible workaround that may still allow you to use powerpoint as a report format option despite the fields not expanding.

 

In this example I created a QS table with two dimensions - "Year" and "Product Name". Then reload the NPrinting Connection to the source QVF.

In the template editor

  • add the year product named table to the 'page' feature
  • add two slides
  • First slide contains the chart tag (as you have it now)
  • Second slide contains the Product Name field tag and the same chart tag as slide one.
  • Preview

Result:

  • Slide 1: summary of 3 years of data
  • Subsequent slides: Product name data per year

See attached report sample.

If you like I also attached the QVF and NPrinting report.

 

Note that I created a filter with only 3 products so as to reduce the amount of time to product the report.

 

Kind regards...

 

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!