Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alessandro_mari
New 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
Esteemed Contributor

Re: How to take only a record depending on a sorted value

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
Honored Contributor II

Re: How to take only a record depending on a sorted value

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

alessandro_mari
New Contributor III

Re: How to take only a record depending on a sorted value

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

Community Browser