1 Reply Latest reply: Jun 23, 2011 2:38 PM by John Witherspoon RSS

    To sum the spend by the distinct id

      Hi,

      I have a data like

       

      uniqueidSpend
      1$10
      1$10
      1$10
      2$20
      2$20

       

       

      i wanted to sum up the spend by the distinct uniqueid Like

       

      uniqueidSpend
      1$10
      2

      $20

       

       

      using set analysis in qlikview.can anyone help me in this?

       

      Thanks.