Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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 |
Hi,
What is "Itm Serial No" values refers to
1
1
2
3
2
what are this values meaning.
Rgds
Anand
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
HI,
Try this expression.
AutoNumber(Item_No&Line_No,Item_No) as Auto_No
Regards,
Kaushik Solanki
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
Hi,
See the updated file
Let me know about this
HTH
Rgds
Anand
Hi ,
Working perfectly as desired. Good work!
Thanks..Vinod
Hi,
Thanks i am glad to help you, if you got correct answer so mark it correct under my post.
Rgds
Anand
Thank You Anand I got it
Regards,
Mike S.