Pivot Tables Still Forbidden? - Apr 2020

[JustinDallas]

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

[Frank_S · Accepted solution]

@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...

[Frank_S]

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.

[JustinDallas]

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]

@JustinDallas

..It happens

No worries!