5 Replies Latest reply: Jul 9, 2018 10:52 AM by Ruggero Piccoli RSS

    NPrinting Pivot Table w/ Pages

    Michael Burt

      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

        • Re: NPrinting Pivot Table w/ Pages
          Ruggero Piccoli

          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.

            • Re: NPrinting Pivot Table w/ Pages
              Michael Burt

              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.

              • Re: NPrinting Pivot Table w/ Pages
                Arindam Sadhu

                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.

                  • Re: NPrinting Pivot Table w/ Pages
                    Ruggero Piccoli

                    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.