How To Display "duplicates" only in a List Box?

[Anonymous]

Hello:  I have the following Excel source:

DogId	DogName
1	Rex
2	Jack
3	Jack
4	Ginger
5	Clancy
6	Casey
7	Casey
8	Tommy

and the following script:

[DOGNAMES]:

LOAD DogId,

     DogName

FROM

(ooxml, embedded labels, table is Sheet1);

and the following expression in a List Box:

=aggr(Only({1<DogName={"=Count(DogName)>1"}>}DogName), DogName

This does display Dog Names that have been duplicated.  But it also displays the DogId of dogs that do not have duplicate names.  My question is, "is it possible to display only the duplicates" ? 

Thanks very much

David

[nagaiank · Accepted solution]

It shows only two entries as seen above.

[maxgro]

=if(aggr(count(DogName),DogName)>1,DogName)

[Anonymous]

Hi NagaianK:

Thanks very much.  I had a couple of unnecessary steps in my work.  When I took a closer look at your minimalist solution it worked perfectly.

Best regards

David

[MK_QSL]

Believe me,  everyone has given correct answer but may be there was some mistake happening your end.

Never mind,  happy learning and Qliking!

[Anonymous]

Hi Manish:

Yes, your solution is correct.  I did have a couple of "extra" things going on and once I simplified it all everything works.  I am so very grateful to the QlikView Community for their help.  I am fast-becoming a huge QlikView fan and want to learn as much as I can about it.  Your insights and those of the other respondents are a big part of that.

Thanks

David