topic Query about Auto number in QlikView

Query about Auto number

Wed, 21 Sep 2011 09:55:36 GMT

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.

Query about Auto number

Wed, 21 Sep 2011 09:59:31 GMT

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

Query about Auto number

its_anandrjs — Wed, 21 Sep 2011 10:05:11 GMT

Hi,

What is "Itm Serial No" values refers to

what are this values meaning.

Rgds

Anand

Query about Auto number

Wed, 21 Sep 2011 10:09:34 GMT

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

Query about Auto number

kaushiknsolanki — Wed, 21 Sep 2011 10:27:25 GMT

HI,

Try this expression.

AutoNumber(Item_No&Line_No,Item_No) as Auto_No

Regards,

Kaushik Solanki

Re: Query about Auto number

its_anandrjs — Wed, 21 Sep 2011 10:41:29 GMT

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

Re: Query about Auto number

its_anandrjs — Wed, 21 Sep 2011 10:58:25 GMT

Hi,

See the updated file

Let me know about this

HTH

Rgds

Anand

Query about Auto number

Wed, 21 Sep 2011 10:58:59 GMT

Hi ,

Working perfectly as desired. Good work!

Thanks..Vinod

Query about Auto number

its_anandrjs — Wed, 21 Sep 2011 11:39:11 GMT

Hi,

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

Rgds

Anand

Query about Auto number

Thu, 22 Sep 2011 01:30:20 GMT

Thank You Anand I got it

Regards,

Mike S.