QLIK Sense Expression

[WeePecky]

Hi,

I have data that looks simiilar to this:

ID Name
1  George

2 George

3 George

4 Henry

5 Henry

6 Fred

7 Fred

8 Fred

9 Fred

I need to calculate a kpi that counts the number of ID's with 3 or more names the same.

Any assistance greatly appreciated

Thanks

[JordyWegman]

Hi WeePecky,

You need to aggregate this data in combination with an if before you can count it. Use this formula:

Sum(Aggr(IF(Count(Name)>=3,Count(Distinct Name)),Name))

Jordy

Climber

[sunny_talwar]

Another option is to do this

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