topic Re: Record counter for a field in QlikView

Record counter for a field

adriano_fornoni — Tue, 24 Nov 2015 15:18:05 GMT

Hi all,

I have to build a script to create a table like this:

Gourp	Detail	Flag (to create)
10	5	1
10	4	2
10	3	3
11	8	1
11	7	2
11	5	3
12	10	1
12	3	2

The table key is the fields union Group and Detail, the Flag field is the one I have to generate.

For each Group different value must have the Flag field is renewed and assumes a progressive function of the Detail field.

Can you tell me at least one function that can help me?

Bye and thanks

Re: Record counter for a field

sunny_talwar — Tue, 24 Nov 2015 16:06:15 GMT

This?

Table:

LOAD *,

If(Gourp = Previous(Gourp), RangeSum(Peek('Flag'), 1), 1) as Flag;

LOAD Gourp,

Detail

FROM

[https://community.qlik.com/thread/192818]

(html, codepage is 1252, embedded labels, table is @1);

Re: Record counter for a field

settu_periasamy — Tue, 24 Nov 2015 16:19:20 GMT

One More approach..

Load *,AutoNumber(RecNo(),Gourp) as Flag;
LOAD Gourp, 
     Detail
FROM
[https://community.qlik.com/thread/192818]
(html, codepage is 1252, embedded labels, table is @1);

Re: Record counter for a field

sunny_talwar — Tue, 24 Nov 2015 16:22:07 GMT

Hey Settu‌

Would you be able to guide me on how can I share script like this?

I have tried to do this before, but not really sure how this format can be applied while pasting a script.

Thanks,

Sunny

Re: Record counter for a field

settu_periasamy — Tue, 24 Nov 2015 16:29:53 GMT

Hi Sunny,

in the Advanced Editor..

Re: Record counter for a field

sunny_talwar — Tue, 24 Nov 2015 16:30:37 GMT

Oh okay, thank you so much

Re: Record counter for a field

settu_periasamy — Tue, 24 Nov 2015 16:32:00 GMT

No Problem 🙂

Re: Record counter for a field

adriano_fornoni — Tue, 24 Nov 2015 16:44:25 GMT

Thanks all

Re: Record counter for a field

effinty2112 — Tue, 24 Nov 2015 16:59:30 GMT

AutoNumber(RecNo(),Gourp) as Flag

is really, really neat!