topic Re: Count up same values in script in QlikView

Count up same values in script

luke1986 — Tue, 21 Jun 2016 14:37:27 GMT

Hello Friends,

This seems like an easy problem, but i couldnt find a solution.

Is it possible to count up the same values in the Script, so that it starts counting from 1 everytime the Value changes?

Sample Data:

Value	Output
A	1
B	1
C	1
C	2
C	3
D	1
E	1
F	1
F	2

Thanks for your time, Lukas

Re: Count up same values in script

marcus_malinow — Tue, 21 Jun 2016 16:02:10 GMT

Yes!

LOAD

Value,

if(Value <> peek('Value', -1), 1, peek('Output', -1) + 1) as Output

FROM

[Source]

ORDER BY Value

Re: Count up same values in script

marcus_malinow — Tue, 21 Jun 2016 16:03:11 GMT

Note though that depending on your source you might not be able to ORDER BY. If this is the case load first into a temporary table, then use a RESIDENT load, and ORDER that.

Re: Count up same values in script

Clever_Anjos — Tue, 21 Jun 2016 16:14:56 GMT

LOAD Value,

Output,

AutoNumber(RecNo(),Value) as CalculatedOutput

FROM

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

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

Re: Count up same values in script

luke1986 — Tue, 21 Jun 2016 17:13:20 GMT

Thanks Marcus, worked out really well!