1 Reply Latest reply: Oct 18, 2017 10:00 AM by Ruggero Piccoli RSS

    how to show pivot table in nprinting excel report

    srinivas jonnakuti

      In Nprinting excel  how to create pivot table , while fetching pivot table object from Qliksense not shown in Nprinting table objects. meantime I want create pivot table in Nprinting report. usually drag n drop columns in exel sheet . I used insert pivot table from insert menu in excel . is it right format

        • Re: how to show pivot table in nprinting excel report
          Ruggero Piccoli

          Qlik NPrinting supports Excel pivot tables. You can create them in your reports in the following two ways:

          - Creating an Excel pivot table report using levels ‒ Qlik NPrinting

          - Creating pivot table using Excel table columns ‒ Qlik NPrinting

          In both cases you must start from a QlikView or a Qlik Sense straight table. If you have a pivot table you can clone it and convert the clone into a straight. Then refresh the metadata and use the new clone.

           

          If you add a Qlik Sense or QlikView pivot table in the Tables node you will nod see the single columns. So you cannot drag and drop each column manually.

           

          As alternative you can add the original pivot as Images.

           

           

          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.