What is the use of FirstSortValue in QlikView?

[#1]

Hi All,

What is the use of FirstSortValue in QlikView?

Thanks in Advance.

[sunny_talwar]

See if this link helps: Value Associated with Min/Max Value of Another Field (Front End Solution)

[Clever_Anjos]

Basically when you want to calculate a rank based on an aggregation on another field

FirstSortedValue( Customer, aggr(-sum(sales),Customer))) will bring you the Customer with highest sales