topic Re: Autogenarate Numbers in QlikView

Autogenarate Numbers

sunilkumarqv — Thu, 27 Nov 2014 08:04:09 GMT

Hi need to auto generate ids based on the numbers like

Examples

slno, num, Autogerate

1, 1 , 1

2, 1, 2

3, 23, 1

4, 23, 2

5, 23, 3

6, 23, 4

7, 12, 1

8, 12, 2

9, 15, 1

If u noticed autogerate column

for first two common numbers 1,2 and next 3 to 6 slno should repeated numbers 1,2... similarly so on , im wondering ill get any help

Re: Autogenarate Numbers

ali_hijazi — Thu, 27 Nov 2014 08:07:38 GMT

temp:

load slno, num

resident your table order by num asc;

load * , if (rowNo() = 1 or num<> previous(num),1,peek(Autognerate) + 1) as AutoGenerate

resident temp;

drop table temp;

Re: Autogenarate Numbers

its_anandrjs — Thu, 27 Nov 2014 08:17:48 GMT

Hi,

Try this ways

LOAD

slno, num, Autogerate,

if(num = Previous(num),Peek(Num)+1,1 ) as AutogerateNew;

LOAD * INLINE [

slno, num, Autogerate

1, 1, 1

2, 1, 2

3, 23, 1

4, 23, 2

5, 23, 3

6, 23, 4

7, 12, 1

8, 12, 2

9, 15, 1

];

And you get this table fields

Regards

Anand

Re: Autogenarate Numbers

tresB — Thu, 27 Nov 2014 08:23:17 GMT

Easier way should be like:

Load

slno,

num,

Autonumber(slno,num) as AutoGenSeq

...