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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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