Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi Alex,
Try this,
=COUNT({$<Person = {"=Sum(Total) > 0 “} Entity Value)
=count({< Person = {"=sum(Total) > 0"} >} Person )
Hi Alex,
Try this,
=COUNT({$<Person = {"=Sum(Total) > 0 “} Entity Value)
Hi Aleksander,
PFA Hope it will work for you........
- Regards,
Vishal Waghole
Hi VishalWaghole.
Unfortunately I have personal edition QlikView and I can't open your file.
Thanks for help anyway!