Ranking in script

[martynlloyd]

Does anyone have an example of ranking a list (example Customer, Sales), in the script?

EG

Customer     Sales     Rank

ABC              1000      2

DEF               1200     1

XYZ               900        3

Regards

Marty.

[its_anandrjs]

Hi,

Yes you can do in load script with Autonumber and order it desc by sales

Data:
LOAD * INLINE [
    Customer, Sales
    ABC, 1000
    DEF, 1200
    XYZ, 900
    eeee, 2300
];

NoConcatenate
FinalTable:
LOAD
Customer, Sales,AutoNumber(Sales) as RankNew Resident Data Order By Sales desc;

DROP Table Data;

Regards

Anand

[maxgro · Accepted solution]

with an order by ?

a:

load * inline [

Customer,     Sales,     Rank

ABC     ,         1000 ,     2

DEF     ,          1200,     1

XYZ     ,          900 ,       3

];

b:

load *, rowno() as newrank

Resident a

order by Sales desc;

[hugmarcel]

Hi

see my example file rank.qvw.

- it contains a sub providing flexible ranking mechanisms,
  such as ranking by autonumber or by row().
- ranks can be split into half ranks for identical values
  (e.g. rank 11,12,13 -> 12, 12, 12)

https://community.qlik.com/docs/DOC-13949

Regards - Marcel