topic Flagging peek value in QlikView

Flagging peek value

arpitkharkia — Tue, 20 Feb 2018 19:32:59 GMT

Hi all,

I am using Peek() function to flag my peek values. So according to my logic if a values occurs second time in a particular field i flag it as 1. So if A occurs twice the second record is flagged 1, 2 for B, 3 for C and so on.

I need to flag the previous record with the same flag. So the first record of where A occurs should be 1,B will be 2 and so.

What i have

Field1	Flag
A
A	1
B
B	2

What i need

Field1	Flag
A	1
A	1
B	2
B	2

Thanks!

Re: Flagging peek value

sunny_talwar — Tue, 20 Feb 2018 20:01:34 GMT

Not sure I understand completely, but may you need AutoNumber()

AutoNumber(Field1)

Re: Flagging peek value

isingh30 — Tue, 20 Feb 2018 20:38:28 GMT

Your requirement is not clear to me. What exactly you need?

Thank you!