Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
alessandro_mari
Partner - Contributor III
Partner - Contributor III

How to take only a record depending on a sorted value

Good evening experts,

i need some help.

I have the situations below:

Cattura.JPG

Cattura.JPG

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

3 Replies
YoussefBelloum
Champion
Champion

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
Partner - Champion
Partner - Champion

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

alessandro_mari
Partner - Contributor III
Partner - Contributor III
Author

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