Count where Sum > 0

[#1]

Let's assume we have

Person

{

     Name

}

and

Account

{

     Person

     Total

}

How can I count Persons who has Sum of all his/shes Totals > 0?

COUNT({$<........>}Name)

[#2]

=count({< Person = {"=sum(Total) > 0"} >} Person )

[#3 · Accepted solution]

Hi Alex,

Try this,

=COUNT({$<Person = {"=Sum(Total) > 0 “} Entity Value)

[VishalWaghole]

Hi Aleksander,

PFA Hope it will work for you........

- Regards,

Vishal Waghole

[#5]

Hi VishalWaghole.

Unfortunately I have personal edition QlikView and I can't open your file.

Thanks for help anyway!