topic Re: How to match repeated values in QlikView

How to match repeated values

sculptorlv — Wed, 25 Nov 2020 16:16:04 GMT

Hello again. I really hope for your help!

I have such table:

Nr. Descripiont. Value

001 AA hotel

002 BB motel

003 CC mobile

003 CC cinema

005 DD cinema

006 EE mobile

So, there are possible several values for the last column, and the values are no unique.

I need somhow in qlickview chart to point out Nr. (numbers) wich contain NOT unique values. For my example:

003 CC mobile

003 CC cinema

005 DD cinema

006 EE mobile

Thank you in advance!

sushil353 — Tue, 28 Mar 2017 07:00:34 GMT

Hi,

using script below you can flag all the duplicate items:

Temp:

LOAD *,if(flag >1,1,0) as Flag;

load

*,AutoNumber(f1,f2) as flag Inline

[

number,f1,f2

001,AA,hotel

002,BB,motel

003,CC,mobile

003,CC,cinema

005,DD,cinema

006,EE,mobile

];

Left Join

LOAD f2,1 as duplicateflag

Resident Temp

where Flag =1;

DROP Field flag,Flag;

HTH

Sushil