topic Re: Problem that needs solving. in QlikView https://community.qlik.com/t5/QlikView/Problem-that-needs-solving/m-p/837232#M1016613 <HTML><HEAD></HEAD><BODY><P>sure....create a table chart. dimension: Sales people name</P><P>Expression: sum(Premium)</P><P></P><P>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.</P><P></P><P>For bottom 5 sales people, do the same but select Show only smallest 5.</P></BODY></HTML> Wed, 01 Apr 2015 16:45:14 GMT Anonymous 2015-04-01T16:45:14Z Problem that needs solving. https://community.qlik.com/t5/QlikView/Problem-that-needs-solving/m-p/837231#M1016612 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Wed, 01 Apr 2015 14:32:01 GMT https://community.qlik.com/t5/QlikView/Problem-that-needs-solving/m-p/837231#M1016612 2015-04-01T14:32:01Z Re: Problem that needs solving. https://community.qlik.com/t5/QlikView/Problem-that-needs-solving/m-p/837232#M1016613 <HTML><HEAD></HEAD><BODY><P>sure....create a table chart. dimension: Sales people name</P><P>Expression: sum(Premium)</P><P></P><P>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.</P><P></P><P>For bottom 5 sales people, do the same but select Show only smallest 5.</P></BODY></HTML> Wed, 01 Apr 2015 16:45:14 GMT https://community.qlik.com/t5/QlikView/Problem-that-needs-solving/m-p/837232#M1016613 Anonymous 2015-04-01T16:45:14Z Re: Problem that needs solving. https://community.qlik.com/t5/QlikView/Problem-that-needs-solving/m-p/837233#M1016614 <HTML><HEAD></HEAD><BODY><P>i think this was discussed,right?</P><P><A href="https://community.qlik.com/thread/158357">Question</A></P><P></P><P></P><P>there is any problem with that?</P></BODY></HTML> Wed, 01 Apr 2015 16:48:00 GMT https://community.qlik.com/t5/QlikView/Problem-that-needs-solving/m-p/837233#M1016614 buzzy996 2015-04-01T16:48:00Z