Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show top 10 managers in list box?

i have two fields

manager ,sal

now i want to show top 10 mangers in list box.

please help on

Tha nks,

3 Replies
Not applicable
Author

any one

JonnyPoole
Former Employee
Former Employee

in the list box on the general tab, change the 'field' to 'expression' (last in the list) and enter this:

=if( aggr( rank(  sum(  Salary)),Manager) <=10, Manager)

aveeeeeee7en
Specialist III
Specialist III

Try this Expression:

Sum({$<YourManagerFieldName={"=Rank(Aggr(Sum(YourSalaryFieldName),YourManagerFieldName))<=10"}>}YourSalaryFieldName)

Regards

Aviral Nag