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.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
TomHouseman
Contributor
Contributor

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
sunny_talwar

Try this @TomHouseman 

FirstSortedValue(Customer, -ordervalue)

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

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

 

Chanty4u
Champion III
Champion III

can you try this

 

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