3 Replies Latest reply: May 5, 2014 5:59 AM by Herbert Chitate RSS

    Max, sum aggregate

      Hi All,

       

      I have a database with Area, Client No., Date & Value. A client can appear several times in the database.I would like to sum up all the Max(values) and display the data with Area as the dimension; effectively QlikView will be summing up the largest number at client level. I can't use the lastsortvalue because I have more than one transaction per day per client in some instances.

       

      Thank you

       

      H