Regarding rank() issue?

[d_koti24]

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

[sunny_talwar]

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;

[marcus_sommer]

If your table is sorted like the table above you could simply use rowno() or rowno(total).

- Marcus

[sunny_talwar]

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:

[d_koti24]

Thanks for your quick reply.

is it possible to do this at UI level.

Regards,

[sunny_talwar]

Is this helpful? Not the exact, but do you want 1223456 or 1224567 works?

[d_koti24]

i want this order 1223456