11 Replies Latest reply: Dec 5, 2016 6:04 AM by Sunny Talwar RSS

    Sum of aggregate by dimension

    Jurien Groot

          This is my source data:

      Order IDValue AValue B
      A26
      B54
      B52
      C15
      C15
      C14
      D68

       

      I want my result table in Qlik Sense to be:

      Order IDDistinct Sum Value ASUM Value B
      A26
      B56
      C114
      D68
      Total1434

       

      I tried everything with Aggr, Distinct and Sum, but haven't succeeded yet. Who can point me in the right direction? I would be very grateful!