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: 
Sunil_Kenth
Former Employee
Former Employee

Show Customer Name that has largest outstanding value

Hi,

In a text box, i would like to show the name of Customer that has the largest amount outstanding, a customer can have several transactions with outstanding values so i would need to sum these values and then determine who has the largest.

how can i do this?

The fields i have are CustomerName and OutstandingValue.

Thanks,

Sunil

1 Solution

Accepted Solutions
sushil353
Master II
Master II

Try using:

=Firstsortedvalue(CustomerName, -OutstandingValue)

HTH

Sushil

View solution in original post

2 Replies
sushil353
Master II
Master II

Try using:

=Firstsortedvalue(CustomerName, -OutstandingValue)

HTH

Sushil

Sunil_Kenth
Former Employee
Former Employee
Author

Thanks Sushil