topic Re: Flag duplicate values in QlikView

Flag duplicate values

arpitkharkia — Tue, 04 Apr 2017 06:15:35 GMT

Hi all,

I have the following key

I want a flag depending on the occurrence of the record in the field

if memo 123 repeats again 3 should come and so on. Finally I want to concatenate Memo and Flag.

Thanks!

tresB — Tue, 04 Apr 2017 06:19:06 GMT

try like:

Load

Memo,

AutoNumber(RecNo(), Memo) as Flag,

Memo & AutoNumber(RecNo(), Memo) as MemoKey

From <>;

arpitkharkia — Tue, 04 Apr 2017 06:46:10 GMT

It is working just fine.

Thanks for the fast reply!

Kushal_Chawda — Tue, 04 Apr 2017 06:52:10 GMT

another solution

Data:

LOAD Memo

FROM Table;

Final:

noconcatenate

LOAD Memo,

if(Memo=previous(Memo),peek('Flag')+1,1) as Flag

Memo & if(Memo=previous(Memo),peek('Flag')+1,1) as MemoKey

Resident Data

order by Memo;

drop table Data;

arpitkharkia — Tue, 04 Apr 2017 06:56:30 GMT

This solution is also working.

Thanks for the response!