1 Reply Latest reply: Apr 12, 2017 5:50 AM by Sunny Talwar RSS

    Custom Table

    Andrea Cristiano

      Hi guys,

           I need of your help to implement this kind of table in qlikview.

       

       

      Table_A

      Model

      TypeabTotal

      A

      123
      B314
      C4

      3

      7
      Total86

       

      14

       

      I know how to use the Type's value like a header of table, but I don't know how to calculate the Total row and column.

       

      I use the Pivot table, so I can't calculate the last row, and if I make the Total expression this is calculated for each vale of Type, below there is what I get:

       

      Table_B

      ModelTypeaTotalbTotal
      A1

      1

      22
      B3311
      C4433

       

      Can I get the Table_A, and how?

      Thanks to all