topic Re: Rank of a column in load script in QlikView

Rank of a column in load script

anjali0108 — Mon, 27 Feb 2017 12:34:58 GMT

Hi Experts,

I have a column(let's say Up time) that has values as shown in the screenshot below:

I just want to create another column named as Ranks as shown above that has ranks for the values of the Column Uptime .

I tried showing the Rank properly but it is coming in the pattern shown above.

I do not want to create Rank column in expression instead I want that in load script.

Could anyone please help me to create a column as shown below:

Up Time | Rank

.99 | 4

.98 | 5

1 | 1

1 | 2

1 | 3

Thanks in advance.

Re: Rank of a column in load script

sunny_talwar — Mon, 27 Feb 2017 12:40:49 GMT

May be this:

LOAD Uptime,

RowNo() as Rank

Resident SomeTable

Order By Uptime desc;

Re: Rank of a column in load script

ahaahaaha — Mon, 27 Feb 2017 15:22:18 GMT

Hi Anjali,

The attached file XLS data source. Script code

Directory;

Table1:

LOAD

UpTime,

Rank,

RowNo() as ID

FROM

[3.xlsx]

(ooxml, embedded labels, table is Sheet1);

DROP Field Rank From Table1;

NoConcatenate

Table2:

LOAD

UpTime,

ID,

RecNo() as Rank

Resident Table1

Order By UpTime desc;

Left Join (Table1)

LOAD

ID,

Rank

Resident Table2;

DROP Table Table2;

DROP Field ID From Table1;

Result

Regards,

Andrey

Re: Rank of a column in load script

Anonymous — Tue, 28 Feb 2017 05:42:40 GMT

Hi Anjali,

find the attachment.

R/Murali