5 Replies Latest reply: Mar 17, 2015 4:24 PM by Abhishek Anand RSS

    Row details corresponding to max value

      For the below mentioned data

      Customer Sales

      A 10

      A 20

      A 30

      B 10

      B 20

      B 10

      I want to know the customer with maximum sale. The answer i expect is A. I have got the sum using aggr() function of 60 but don't know how to get "A" as an output. Any help would be highly appreciated. Also i am new to Qlikview so pardon my ignorance. Moreover i also need to find the 2nd and 3rd best customer so if possible please suggest the changes required for that.

       

      Thanks in advance.