Conditional Row Number

poluvidyasagar — Sat, 16 Nov 2024 04:24:13 GMT

Hi,

I am trying to achieve this Row Number function in the script.

Actual Data:

Product	Time
A	2/18/2019 6:45
B	2/18/2019 6:49
C	2/18/2019 6:45
D	2/18/2019 6:49
E	2/18/2019 6:52
F	2/18/2019 6:52
G	2/18/2019 6:55
H	2/18/2019 6:55
I	2/18/2019 6:59
J	2/18/2019 6:59

I would like to generate a row number in order of increasing time column. So the result should look like this.

Product	Time	Seq
A	2/18/2019 6:45	1
B	2/18/2019 6:49	3
C	2/18/2019 6:45	2
D	2/18/2019 6:49	4
E	2/18/2019 6:52	5
F	2/18/2019 6:52	6
G	2/18/2019 6:55	7
H	2/18/2019 6:55	8
I	2/18/2019 6:59	9
J	2/18/2019 6:59	10

I have this script:

Load

Product,

Time,

RowNo() as Seq

From

Data;

How do i put condition on the Row No() to get sequence in the form of time loaded.

I know we can do this using resident load. But any other way around this?

Thanks,
Vidya

Re: Conditional Row Number

rwunderlich — Tue, 19 Feb 2019 16:40:33 GMT

I believe you will have to do a Resident Load with "Order By Time". Only Resident supports the Order By. Alternatively, if you are loading the data with SQL SELECT you could put the Order By on the SQL.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

topic Re: Conditional Row Number in QlikView

Conditional Row Number

Re: Conditional Row Number