Show clients with more than 5 houses

[MarioCenteno]

Hi

I need to show the clients that have more than 5 houses in a table.

In my data I have 2000 clients but only 22 have more than 5 houses, those 22 I need to show in a table.

In the dimension I have the following expression

=if( aggr((count(NAME_CLIENT)),NAME_CLIENT)>5, NAME_CLIENT,)

Expression measure

=Sum(Aggr(if(count(NAME_CLIENT) > 5, 1, 0), NAME_CLIENT))

[Anil_Babu_Samineni]

If you already restrict in dimension, Why you are trying same in expression? Try this using same dimension as yours

=Sum(NAME_CLIENT)

Or

Sum(Aggr(If(Match(Count({<NAME_CLIENT = {"=Count(NAME_CLIENT)>5"}>} NAME_CLIENT),1),NAME_CLIENT),NAME_CLIENT))

My Bad, This?

=Sum(Aggr(if(count(NAME_CLIENT) > 5, 1), NAME_CLIENT))

[sibin_jacob]

If you want to suppress the zero values,

Go to table -> Add-ons Properties -> uncheck Include zero values.

It will eliminate Zero rows in the table.

[sunny_talwar]

Why don't you try this

Dimension

NAME_CLIENT

Expression

Count(DISTINCT {<NAME_CLIENT = {"=Count(NAME_CLIENT) > 5"}>}  NAME_CLIENT)

and now uncheck 'Include Zero Values' under Add-Ons -> Data Handling

[MarioCenteno]

Now it shows me the 22 clients but it does not group how many houses each client has. How do I do that?

[sunny_talwar · Accepted solution]

May be this

Count({<NAME_CLIENT = {"=Count(NAME_CLIENT) > 5"}>}  NAME_CLIENT)

[MarioCenteno]

Thanks Sunny.