Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

skh
Contributor

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

Tags (4)
1 Solution

Accepted Solutions
sushil353
Honored Contributor II

Re: Show Customer Name that has largest outstanding value

Try using:

=Firstsortedvalue(CustomerName, -OutstandingValue)

HTH

Sushil

2 Replies
sushil353
Honored Contributor II

Re: Show Customer Name that has largest outstanding value

Try using:

=Firstsortedvalue(CustomerName, -OutstandingValue)

HTH

Sushil

skh
Contributor

Re: Show Customer Name that has largest outstanding value

Thanks Sushil

Community Browser