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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem that needs solving.

Is the a way I can show the top 5 sales people names for policies created and the bottom 5 sales people names for policies created

1 Solution

Accepted Solutions
buzzy996
Master II
Master II

i think this was discussed,right?

Question

there is any problem with that?

View solution in original post

2 Replies
Anonymous
Not applicable
Author

sure....create a table chart. dimension: Sales people name

Expression: sum(Premium)

In dimension limits tab, check the first option to Restrict which values are displayed using first expression and select Show only Largest 5. Uncheck Show Others in Option section of the tab.

For bottom 5 sales people, do the same but select Show only smallest 5.

buzzy996
Master II
Master II

i think this was discussed,right?

Question

there is any problem with that?