topic How to List top 3 values in text box in QlikView

How to List top 3 values in text box

fashid — Tue, 07 Feb 2017 05:21:37 GMT

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

Re: How to List top 3 values in text box

vinieme12 — Tue, 07 Feb 2017 06:19:32 GMT

try the below

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

Re: How to List top 3 values in text box

maxgro — Tue, 07 Feb 2017 06:28:11 GMT

this could help

Qlik Design Blog : Displaying the Top Salespers... | Qlik Community

Show Top Performers | Qlik Community

Re: How to List top 3 values in text box

uacg0009 — Tue, 07 Feb 2017 06:47:32 GMT

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