Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for
Search instead for
Did you mean:
Specialist

## How to List top 3 values in text box

Hi Friends,

I have created rank table basis on my expression .

Now i need to display the top three ranker in a text object . The below is the table that  have created.

And the below is the outcome that i need . I am able to get the names but need to know how to get the correct value against the names.

Regards,

Nadeem

1 Solution

Accepted Solutions
Champion III

try the below

Concat(AGGR(IF(Rank(YourExpression)<=3, Manager & ' Your Text' & YourExpression),Manager),''&chr(10), aggr(rank(YourExpression), Manager))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
3 Replies
Champion III

try the below

Concat(AGGR(IF(Rank(YourExpression)<=3, Manager & ' Your Text' & YourExpression),Manager),''&chr(10), aggr(rank(YourExpression), Manager))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
MVP
Partner - Specialist

Hi Nadeem,

I think Rank is also a cool method just like Vineeth said.

And I use another way to make it :

The expression is :

='1. ' & FirstSortedValue(Manager,-Process) & ' - ' & FirstSortedValue(Process,-Process) & chr(10) &

'2. ' & FirstSortedValue(Manager,-Process,2) & ' - ' & FirstSortedValue(Process,-Process,2) & chr(10) &

'3. ' & FirstSortedValue(Manager,-Process,3) & ' - ' & FirstSortedValue(Process,-Process,3)

Thank Vineeth for the remind of using chr(10).

Aiolos Zhao

Community Browser