Query about Auto number

[#1]

Dear Frds,

Am new to QlikView and I couldn't find any solution for below logic, if any one knows please help me

The Logic is

My Table is like this

Line No.	Item No.	Other Data
1	1000
2	1001
3	1000
4	1000
5	1001

And My required table from above one is

Line No.	Item No.	Other Data	Itm Serial No
1	1000		1
2	1001		1
3	1000		2
4	1000		3
5	1001		1

I know about AutoNumber syntax in Qlikview, it will give the result as the Unique number for sames data but my requirement is totally opposite way.

Please help me to get solution for this.

With Regards,

Mike S.

[#2]

Sorry the 2nd table value should be as shown below

Line No.	Item No.	Other Data	Itm Serial No
1	1000		1
2	1001		1
3	1000		2
4	1000		3
5	1001		2

[its_anandrjs]

Hi,

What is "Itm Serial No" values refers to

1

1

2

3

2

what are this values meaning.

Rgds

Anand

[#4]

Hi anand,

I think Itm serial no is nothing but  sequence of occurances.

Line no  Item no   comments

1          1000        this is first occurance of item no =1000, so the Item serial no =2

3          1000        this is scond occurance of item no =1000 , so the Item serial no =2

like wise for other records as well inrespective of Line no.

Regards

Vinod

[kaushiknsolanki]

HI,

    Try this expression.

    AutoNumber(Item_No&Line_No,Item_No) as Auto_No

Regards,

Kaushik Solanki

[its_anandrjs · Accepted solution]

Hi,

Ok understood you need to add another column as Auto_No

Data:

load * inline

[

LineNo,          ItemNo

1,          1000

2,          1001

3,          1000

4,          1000

5,          1001

];

load

*,

AutoNumber(LineNo,ItemNo) as Auto_No

Resident Data;

See the sample file

Rgds

Anand

[its_anandrjs]

Hi,

See the updated file

Let me know about this

HTH

Rgds

Anand

[#8]

Hi ,

Working perfectly as desired. Good work!

Thanks..Vinod

[its_anandrjs]

Hi,

Thanks i am glad to help you, if you got correct answer so mark it correct under my post.

Rgds

Anand

[#10]

Thank You Anand I got it

Regards,

Mike S.