topic Re: Add Counter ToLoaded Table in QlikView

Add Counter ToLoaded Table

Thu, 08 Dec 2011 07:01:16 GMT

Source Table:

ITEM

A0001

A0002

A0001

A0002

A0003

Result Table:

COUNTER ITEM

1 A0001

2 A0001

3 A0001

4 A0001

1 A0002

2 A0002

3 A0002

1 A0003

2 A0003

Result Table should be sorted by ITEM then a counter from 1 to total counter per counter is created.

Thanks guys for you help.

~skip~

Add Counter ToLoaded Table

Thu, 08 Dec 2011 07:10:07 GMT

Hi, Try to use the recno() function it will help you.

Regards,

Nitin Jain

Add Counter ToLoaded Table

Thu, 08 Dec 2011 07:15:44 GMT

Does not reset to one when new ITEM is loaded.

Add Counter ToLoaded Table

Thu, 08 Dec 2011 07:22:39 GMT

Whenever your new data will be loaded the new record number will be generated.

But you don't worry if the some value is coming again and again it will have the same counter.

It won't change.

Regards,

Nitin Jain

Add Counter ToLoaded Table

Thu, 08 Dec 2011 07:25:20 GMT

When I used the RecNo() same output is generated like RowNo():

COUNTER ITEM

1 A0001

2 A0001

3 A0001

4 A0001

5 A0002

6 A0002

7 A0002

8 A0003

9 A0003

The counter is continuous. What I need is same as my example.

It should reset to one when new item is loaded.

Add Counter ToLoaded Table

jagan — Thu, 08 Dec 2011 07:34:48 GMT

Hi,

Check this.

http://community.qlik.com/message/170283#170283

hope this helps you.

Regards,

Jagan.

Add Counter ToLoaded Table

Thu, 08 Dec 2011 07:35:50 GMT

Hi,

Try to use the Autonumber.

For ex. autonumber(ITEM) as counter

Hope this will help you.

Regards,

Nitin Jain

Re: Add Counter ToLoaded Table

rwunderlich — Thu, 08 Dec 2011 07:37:01 GMT

You can use the autonumber() function with ITEM as a grouping and a unique value. Like this

autonumber(recno(), ITEM) as COUNTER

The data doesn't even have to be sorted, unless you want the COUNTER values to be assigned in an order based on some other field.

-Rob

http://robwunderlich.com

Add Counter ToLoaded Table

Thu, 08 Dec 2011 07:43:50 GMT

Thanks Rob...

Re: Add Counter ToLoaded Table

Tue, 20 Dec 2011 10:19:16 GMT

Hello Rob,
Brilliant solution! You saved my day. Thanks very much.
Thomas