Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Contributor III

To find out who the biggest customer is for a product

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

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