This content has been marked as final. Show 3 replies
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.