Aggr without selecting dimension

[Mahamed_Qlik]

Hi 

In below table I have same Name with multiple same ID's

Name	ID
Industry	1
Industry	1
Industry	1
Hotel	2
Hotel	2
Hospital	3

I want to show KPI wherein it should display the count of Name with same ID more than 1.
result should be "2" because Industry and hotel has same ID more than 1 so count of such Name will be 2.

I have used below expresssion but it is working only on selecting any Name, I want it should display by default.
=if(aggr(count(ID),Name)>1,count(Name))

[BrunPierre · Accepted solution]

Hi,

Try it this way?

=Count(If(Aggr(count(ID),Name)>1,Name))

[Mahamed_Qlik]

It works.
Thanks much.

[MarcoWedel]

another solution might be

Count({$<Name={"=Count(ID)>1"}>} DISTINCT Name)