Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
Try with Rank Function
Ex:
https://community.qlik.com/t5/QlikView-App-Dev/Rank-Function-load-script/td-p/834751
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.