Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

arpitkharkia
New Contributor II

Flagging peek value

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

Field1Flag

A

A

1

B
B

2

What i need

Field1Flag
A1
A1
B2
B2

Thanks!

2 Replies

Re: Flagging peek value

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

AutoNumber(Field1)

isingh30
Contributor III

Re: Flagging peek value

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

Thank you!

Community Browser