topic Re: autonumber in QlikView

autonumber

zturaiki — Mon, 27 Jan 2014 12:19:34 GMT

this is my original data Original Data
Id	Date
A1	5/12/13 12:00 AM
A1	5/13/13 12:00 AM
A1	5/14/13 12:00 AM
A1	5/15/13 12:00 AM
B2	5/16/13 12:00 AM
B2	5/17/13 12:00 AM
C4	5/18/13 12:00 AM
C4	5/19/13 12:00 AM
C4	5/20/13 12:00 AM
D5	5/21/13 12:00 AM
E6	5/22/13 12:00 AM
I want That Result From Above
Id	Date	Row No
A1	5/12/13 12:00 AM	1
A1	5/13/13 12:00 AM	2
A1	5/14/13 12:00 AM	3
A1	5/15/13 12:00 AM	4
B2	5/16/13 12:00 AM	1
B2	5/17/13 12:00 AM	2
C4	5/18/13 12:00 AM	1
C4	5/19/13 12:00 AM	2
C4	5/20/13 12:00 AM	3
D5	5/21/13 12:00 AM	1
E6	5/22/13 12:00 AM	1

Re: autonumber

Mon, 27 Jan 2014 12:27:11 GMT

try to use iterNo() function

see attached file

hope this helps you

Regards

Re: autonumber

Mon, 27 Jan 2014 12:31:54 GMT

Hi Zainab,

You can use the Recno() Function like below

Load

id,

Date,

Rowno() As Rowno

From Table1;

Regards,

Santhosh G

Re: autonumber

Peter_Cammaert — Mon, 27 Jan 2014 12:40:16 GMT

See this discussion Re: Re: Numbering Rows more examples? for an example QVW that solves your problem and two other numbering schemes you may have to deal with in the future.

Good luck,

Peter

Re: autonumber

tresB — Mon, 27 Jan 2014 12:40:53 GMT

AutoNumber(Date) as RowNo ?

Re: autonumber

Tue, 28 Jan 2014 03:57:07 GMT

According to your requirement. try this code or see attachment.

[Original Data]:

LOAD Id, date(Date#(Date,'M/DD/YY hh:mm TT'),'M/DD/YY hh:mm TT') as Date_new,

if(Previous(Id)<>(Id),1, RangeSum(1,Peek(RowNo))) as RowNo ;

LOAD * Inline [

Id, Date

A1, 5/12/13 12:00 AM

A1, 5/13/13 12:00 AM

A1, 5/14/13 12:00 AM

A1, 5/15/13 12:00 AM

B2, 5/16/13 12:00 AM

B2, 5/17/13 12:00 AM

C4, 5/18/13 12:00 AM

C4, 5/19/13 12:00 AM

C4, 5/20/13 12:00 AM

D5, 5/21/13 12:00 AM

E6, 5/22/13 12:00 AM

then output like this--

Id	Date_new	RowNo
A1	5/12/13 12:00 AM	1
A1	5/13/13 12:00 AM	2
A1	5/14/13 12:00 AM	3
A1	5/15/13 12:00 AM	4
B2	5/16/13 12:00 AM	1
B2	5/17/13 12:00 AM	2
C4	5/18/13 12:00 AM	1
C4	5/19/13 12:00 AM	2
C4	5/20/13 12:00 AM	3
D5	5/21/13 12:00 AM	1
E6	5/22/13 12:00 AM	1

Re: autonumber

zturaiki — Tue, 28 Jan 2014 12:52:05 GMT

the data i have not load in order

Re: autonumber

kumarnatarajan — Tue, 28 Jan 2014 13:00:09 GMT

Hi Zainab,

Try below syntex.

Ex:

AutoNumber(Date,Id) as RNo

Re: autonumber

Tue, 28 Jan 2014 13:00:19 GMT

Yu need to sort it if you want to do that

Do a second resident load and do an ORDER BY

Fabrice

Re: autonumber

zturaiki — Wed, 29 Jan 2014 04:49:35 GMT

resident load , is difficult , table size is very big

Re: autonumber

zturaiki — Wed, 29 Jan 2014 05:04:12 GMT

it take more time

Re: autonumber

Wed, 29 Jan 2014 05:58:32 GMT

Use Rownum ()

its very common to use auto genrate numbers.

Regards

Asim

Re: autonumber

sunilkumarqv — Wed, 29 Jan 2014 06:22:36 GMT

Good work done by VISHWARANJAN and

to Zainab make order by date in your script table things done easy.

Re: autonumber

Anonymous — Wed, 29 Jan 2014 06:56:59 GMT

Load

field1,

field2,

Rowno() As Rowno

From yourtable;

anant

Re: autonumber

Wed, 29 Jan 2014 08:01:34 GMT

Hi Vishwa,

Could please let know for the above mentioned data and one more request(while loading the data from excel how to do the same).

Regards,

Rajesh