Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

Displaying field associated with a set

Assume I have order data - order#, customer, date, order value, etc.

How can I display the customer who gave the order with the highest value.  Listing a KPI with the max(ordervalue) is simple enough, but in the title, I would like to display the customer who placed that order.

2 Replies

Try this @TomHouseman 

FirstSortedValue(Customer, -ordervalue)

or this if you want the Customer by Sum(ordervalue)

FirstSortedValue(Customer, -Aggr(Sum(ordervalue), Customer))


Champion III
Champion III

can you try this


=Max(Aggr(Sum(OrderValue), Customer))