topic Re: Count where Sum > 0 in QlikView

Count where Sum > 0

Tue, 17 Dec 2013 17:20:06 GMT

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)

Tue, 17 Dec 2013 17:38:23 GMT

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

Tue, 17 Dec 2013 17:54:12 GMT

Hi Alex,

Try this,

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

VishalWaghole — Tue, 17 Dec 2013 17:55:35 GMT

Hi Aleksander,

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

- Regards,

Vishal Waghole

Tue, 17 Dec 2013 20:25:38 GMT

Hi VishalWaghole.

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

Thanks for help anyway!