topic Re: Regarding rank() issue? in QlikView

Regarding rank() issue?

d_koti24 — Mon, 17 Aug 2015 11:03:41 GMT

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,

Re: Regarding rank() issue?

sunny_talwar — Mon, 17 Aug 2015 11:08:23 GMT

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;

Re: Regarding rank() issue?

marcus_sommer — Mon, 17 Aug 2015 11:09:30 GMT

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

- Marcus

Re: Regarding rank() issue?

sunny_talwar — Mon, 17 Aug 2015 11:19:25 GMT

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:

Re: Regarding rank() issue?

d_koti24 — Mon, 17 Aug 2015 12:17:09 GMT

Thanks for your quick reply.

is it possible to do this at UI level.

Regards,

Re: Regarding rank() issue?

sunny_talwar — Mon, 17 Aug 2015 12:22:54 GMT

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

Re: Regarding rank() issue?

d_koti24 — Mon, 17 Aug 2015 12:33:27 GMT

i want this order 1223456