How to take only a record depending on a sorted value

[alessandro_mari]

Good evening experts,

i need some help.

I have the situations below:

In the first one i need to take only the SalesPerson with the major Split value.

In the second one i need to take only the first SalesPerson (in alphabetical order) instead.

Any suggest?

Tanks in advance.

Alessandro Marini

[YoussefBelloum]

Hi,

on the front-end you can try to use FirstSortedValue() function

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/BasicAggregationFun...

like this:

FirstSortedValue(SalesPerson,-sum(Split))

[agigliotti]

I think you should use what youssefbelloum‌ said above as a calculated dimension.

[alessandro_mari]

I have just try to use FirstSortedValue function.

In the first situation it perfectly works but in the second case it turn to me a null value