Help with set expression - Count only if Aggr is in range ?

[stockisteven]

I am trying to create a set expression where it calculates only Names that have an Aggr count within a range

For example below - If I only wanted to calculate a measure for names to which only have a total count value of > 4, then only Steve would be included.

What am I doing wrong ? Thanks !!

Steven(5)      Sean(3)

H1234           E9384

H5678           E9393

H6656           E334

H9989

H9445

[vishsaggi]

Can you share your qvf file to look into?

[Anil_Babu_Samineni]

What you shown in image wrong.. But, Try to explain your needed

[sunny_talwar]

May be this

Count({1<[PCP Full Name] = {"=Count(PCPanel) > 2000"}>}PVPanel)

[stockisteven]

Hi Sunny,

Appreciate the response - but that only works on the selection.

I want this expression to look at all the names - irregardless of the current selection.

I'm think the aggr function needs to be involved.

[vishsaggi]

Extending Sunny's expression may be you can try like below?

= Count({1<[PCP Full Name] = P({< [PCP Full Name] = {"=Count(PCPanel) > 2000"} >} [PCP Full Name])  >} PVPanel)

[sunny_talwar]

May be, but don't really have enough information to know what you have and what you might need... would you be able to share a sample?