Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist II
Specialist II

Pivot Tables Still Forbidden? - Apr 2020

Hello Folks,

 

Are Pivot Tables still persona non-grata in terms of NPrinting?  I've refreshed my Connection metadata and I still can't see my pivot tables.

 

Sincerely,

  Justin Dallas

 

Labels (2)
1 Solution

Accepted Solutions
Frank_S
Support
Support

@JustinDallas 

It should work. QS Pivot Tables have been supported for some time now.

https://help.qlik.com/en-US/nprinting/April2020/Content/NPrinting/ReportsDevelopment/Qlik-objects-su...

If 'chart assistance' is turned on then I suggest that you disable it, save the QS app, then reload your NP connection again.

You can also test your QS app with chart assistance turned off by:

  • Creating a test NP App
  • Within this new NP App, create a new NP connection to you QS app that has chart assistance turned off
  • Create a new report using this new np connection/np app and try add your QS pivot table to the report template within the NP designer.

Does it work? If not can you share a sample app here so we can test it?

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!

View solution in original post

4 Replies
Frank_S
Support
Support

@JustinDallas 

It should work. QS Pivot Tables have been supported for some time now.

https://help.qlik.com/en-US/nprinting/April2020/Content/NPrinting/ReportsDevelopment/Qlik-objects-su...

If 'chart assistance' is turned on then I suggest that you disable it, save the QS app, then reload your NP connection again.

You can also test your QS app with chart assistance turned off by:

  • Creating a test NP App
  • Within this new NP App, create a new NP connection to you QS app that has chart assistance turned off
  • Create a new report using this new np connection/np app and try add your QS pivot table to the report template within the NP designer.

Does it work? If not can you share a sample app here so we can test it?

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!

View solution in original post

Frank_S
Support
Support

I've tested with Nov. 2019 (new versions will work the same)

Notice the object in the template editor, it is not expandible (no '+' sign next to the table indicating a pivot table)

Works as designed if chart assistance is turned off.

Pivot Table export in NP.PNG

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!
JustinDallas
Specialist II
Specialist II
Author

I'm not too smart.  I had my connection pointed to a dashboard in the "Trash Can" stream with the same name.  So it was loading on schedule (it shouldn't have been), but wasn't picking up the updates from the correct dashboard in the public stream.

Frank_S
Support
Support

@JustinDallas

..It happens

No worries!

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!