Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

michaeldburt
New Contributor II

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

Re: NPrinting Pivot Table w/ Pages

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.
5 Replies
Employee
Employee

Re: NPrinting Pivot Table w/ Pages

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
New Contributor II

Re: NPrinting Pivot Table w/ Pages

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.

Employee
Employee

Re: NPrinting Pivot Table w/ Pages

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.

arindamsadhu1
New Contributor

Re: NPrinting Pivot Table w/ Pages

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.

Employee
Employee

Re: NPrinting Pivot Table w/ Pages

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