6 Replies Latest reply: Apr 3, 2017 11:19 AM by Camillo Rospigliosi RSS

    Sum AGGR divided by

    Camillo Rospigliosi

      Hi experts,

       

      on a dynamic straight table, in the column "Dim3 Value" I obtain the following result with "sum(aggr(Value,Dim1,Dim3))"

       

      Dim 1Dim 2Dim 3Dim3 Value
      TOTAL: 140
      ABE0
      ABF0
      ABG0
      ACE0
      ACF0
      ACG0
      ADE84
      ADF15
      ADG41

       

      But I would like to obtain this:

      Dim 1Dim 2Dim 3Dim3 Value
      Total: 140
      ABE84
      ABF15
      ABG41
      ACE84
      ACF15
      ACG41
      ADE84
      ADF15
      ADG41

       

       

      I tried to do this: "sum(aggr(Value,Dim1,Dim3,Dim2))/count (distinct Dim2)", it work only if the DIM1 is only one selected value (in my example the selected value is "A") but if i select more than one DIM1 my qlikview desktop freezes my laptop.