topic Re: Using peek or for loop in QlikView

Using peek or for loop

Tue, 08 Sep 2015 10:25:06 GMT

Hello,

I have a table with 2 ID columns ID1 and ID2.

As you can see there can be 2 ID2 for same ID1.

Column ProjectID has a numbering based on the unique ID1.

Im having trouble having a sub numbering for ID2. I don't know if I have to use peek function or a for loop.

If there are 2 ID2 for ID1, I need a new column which indicates sub rank 1,2.

If there is 1 ID2 for ID1, I need to display 1 if there are 3 ID2 grouped under ID 1, I need to have a numbering 1,2,3

Any help on this would be appreciated.

Thank you!

Re: Using peek or for loop

Tue, 08 Sep 2015 10:26:52 GMT

Re: Using peek or for loop

Tue, 08 Sep 2015 10:27:45 GMT

I'm able to add a total count of the sub id, but able to to a numbering...

Re: Using peek or for loop

Tue, 08 Sep 2015 10:29:35 GMT

Or do I have to use a pick() function?

Re: Using peek or for loop

tresB — Tue, 08 Sep 2015 10:34:41 GMT

Try like:

Autonumber(Rowno(), ID1) as Counter

Edit: Corrected

Re: Using peek or for loop

Tue, 08 Sep 2015 10:42:37 GMT

Ah! i thought it nearly worked, but noit's not numbering correctly...

Re: Using peek or for loop

sunilkumarqv — Tue, 08 Sep 2015 10:43:25 GMT

autonumber(ID1,ID2) as NewID

from datasource;

autonumber(ID2,ID1) as NewID

from datasource;

Re: Using peek or for loop

Tue, 08 Sep 2015 10:45:54 GMT

Hi Hero,

If you just need to create a new id for each ID2 grouped by ID1, you could try autonumber(ID2,'ID_Inc' & ID1) as ID2_PK

Re: Using peek or for loop

sunilkumarqv — Tue, 08 Sep 2015 10:47:17 GMT

@check the file

Re: Using peek or for loop

tresB — Tue, 08 Sep 2015 10:48:01 GMT

If you are numbering the combinations (ID1 and ID2), try like:

Autonumber(ID2, ID1) as Counter

Re: Using peek or for loop

Tue, 08 Sep 2015 12:32:47 GMT

Autonumber(ID2, ID1) as Counter did the trick!

Had never used earlier autonumber with 2 parameters! Thanks a lot!

Re: Using peek or for loop

Tue, 08 Sep 2015 12:33:15 GMT

Thank you for the example. It works perfectly!

You guys are great!