top 10 and bottom 10 salesman??

[kalaino1]

HII, I want to find top 10 and bottom 10 salesman.. i have no clue.. if any related  field create on my script???

help me, 

Thanks in advance.

[MayilVahanan]

Hi

Try with Rank Function

Ex:

https://community.qlik.com/t5/QlikView-App-Dev/Rank-Function-load-script/td-p/834751

[kalaino1]

hii, i have salesvalue, and salesman name in my script, but I  cant  find my expression... 

help me ,

LOAD *,

If(Sum(SalesValue<=10 ???

LOAD salesmanName,

SalesValue,

AutoNumber(SalesValue) as Rank

Resident sales

Order By SalesValue;

DROP Table sales;

Exit Script;

Thanks.