3 Replies Latest reply: Jan 18, 2018 10:33 PM by Daniel Jenkins 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.