5 Replies Latest reply: Sep 10, 2015 1:35 PM by Sunny Talwar RSS

    Pivot table cannot display total value

    EDDIE KONG

      Hi community,

       

      My pivot table cannot display total value in Qlik Sense.

       

      The data structure is shown below.

      Type1Type2Value1Value2
      AX18
      BY56
      CY56
      DZ79

       

       

       

      From below pivot table, the total of aggr(max(Value1),Type1, Type2) should be 13. However, it cannot display value.

      total pivot.png

       

      Does anyone help me on this? Thanks.