If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
Try this @TomHouseman
FirstSortedValue(Customer, -ordervalue)
or this if you want the Customer by Sum(ordervalue)
FirstSortedValue(Customer, -Aggr(Sum(ordervalue), Customer))
can you try this
=Max(Aggr(Sum(OrderValue), Customer))