Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I Want rank with out gaps, like this :
Name | num | rank |
---|---|---|
A | 50 | 1 |
B | 70 | 2 |
C | 70 | 2 |
D | 90 | 3 |
E | 100 | 4 |
F | 150 | 5 |
G | 200 | 6 |
Is it possible ?
Thanks &Regards,
kd
May be this:
LOAD Name,
num,
AutoNumber(num) as Rank
FROM Source;
Slight update
Table:
LOAD Name,
num
FROM Source;
NewTable:
LOAD *,
AutoNumber(num) as Rank
Resident Table
Order By num;
DROP Table Table;
If your table is sorted like the table above you could simply use rowno() or rowno(total).
- Marcus
Used the following Script:
Table:
LOAD Name,
num
FROM
[https://community.qlik.com/thread/176812]
(html, codepage is 1252, embedded labels, table is @1);
NewTable:
LOAD *,
AutoNumber(num) as Rank
Resident Table
Order By num;
DROP Table Table;
To get this:
Thanks for your quick reply.
is it possible to do this at UI level.
Regards,
Is this helpful? Not the exact, but do you want 1223456 or 1224567 works?
i want this order 1223456