1 Reply Latest reply: Mar 14, 2016 2:57 AM by Avinash R RSS

    How do I suppress a pivot table column in NPrinting ?

    Maureen Vickers

      Hi Experts,


      I am outputting two QlikView dashboard pivot table objects in NPrinting to an Excel sheet as shown in the screenshot below.


      The Pivot Table 1 has 1 dimension - Month-Year - and 2 expressions - Sales and Enquiries.


      Whereas, Pivot Table 2 has 2 dimensions...

      1. A Month-Year dimension that displays horizontally across the top of the pivot table

      2. A Customer Name dimension that displays vertically as the left-most column in the table.

      ...and an expression of SUM of Sales.


      The output from NPrinting looks like this in Excel:



      And therein lies the problem. Is there any way in QlikView or NPrinting to hide or suppress the blank column in Pivot Table 2 so that the two pivot tables align with each other when outputted to Excel ?


      Also, the date dimension displays as left-aligned, even though the original QlikView table has right-align set on. Why does NPrinting ignore this attribute ?