Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To find out who the biggest customer is for a product

Hello,
I am wondering if anyone knows how to find out the biggest customer for a product is and display it by its name. And also to see how much the customer bought. This data will be used in a table.

Thanks!

1 Reply
isaiah82
Creator III
Creator III

Hi - you can use the FirstSortedValue function to return the customer in this case, using something like:

FirstSortedValue(Customer,-Aggr(Sum(Sales),Customer,Product))