Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
michaeldburt
Partner - Contributor III
Partner - Contributor III

NPrinting Pivot Table w/ Pages

Hi Everyone-

I've created an NPrinting template using a straight table from Qlik Sense, with 4 fields.  After following the steps to create an NPrinting Pivot table in Excel from the Qlik help guide, I've encountered a problem.  It seems as though there is no ability to create a Pivot table that contains the Page capability as well.  When the pages are created, the data set is correct, but the corresponding pivot table only contains data from the first pivot table in the page. 

Is there a way around this?  I'm surprised that the table of data on the page doesn't provide the source for the pivot table on the same page.

Thanks

1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

This bug was solved in November 2017 release. Please update to November 2017 your installation.

From the Release Notes:

Excel pivot tables are supported with Page feature

You can now create Excel pivot tables and straight tables inside worksheets with the Qlik NPrinting Page feature activated. Excel pivot tables must be created in the same worksheet as the table that contains the source data.

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



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.

View solution in original post

7 Replies
Ruggero_Piccoli
Support
Support

Hi,

This bug was solved in November 2017 release. Please update to November 2017 your installation.

From the Release Notes:

Excel pivot tables are supported with Page feature

You can now create Excel pivot tables and straight tables inside worksheets with the Qlik NPrinting Page feature activated. Excel pivot tables must be created in the same worksheet as the table that contains the source data.

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



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.
michaeldburt
Partner - Contributor III
Partner - Contributor III
Author

Thanks for the suggestion.  In upgrading from June 2017 to Nov, I'm now being presented with a TLS handshake error upon testing the distribution of reports via email which will require my attention prior to attempting to create the pivot tables.

Daniel_Jenkins
Specialist III
Specialist III

Hi Michael,

Regarding the TLS handshake issue, if you were unable to resolve it please open a Support case or start a new thread. Either way please include the relevant error from the Engine log (for example., Failed to send e-mail message to emailaddress@domain.com. ERROR: No compatible authentication mechanisms found).

HTH - Daniel.

Anonymous
Not applicable

Hi Ruggero,

I am using Feb 18 Nprinting and still not able to have page implemented in Pivot table.

I am trying to create page for Managers and though tabs are created for different managers, the same data gets replicated all over.

Any idea what trcik am missing ?

Thanks for your help.

RegadRe,

Arindam.

Ruggero_Piccoli
Support
Support

Hi,

First of all please open a different conversation for different issues. Thanks.

I think you need to add filters to the Qlik NPrinting users that are related to managers.

Best Regards,

Ruggero

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

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.



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.
Ram4
Contributor
Contributor

I'm expecting a requirement like ,Nprinting designer contains pivot table with drop down filters and having a data.

This pivot data should split in to another tabs based on the TourID filter.

But I'm getting a result like data is split in excel tabs based on TourID but it is not filtering.same data repeating in all Tabs.

Can anyone help on this.

 

Regards,
Sriram P.

 

 

Ram4
Contributor
Contributor

We are not getting the solution, What you mentioned in the community.we tried same procedure which you mentioned in the community.

Regards,
Sriram P.