Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count where Sum > 0

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)

1 Solution

Accepted Solutions
Highlighted
Not applicable

Hi Alex,

Try this,

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

View solution in original post

4 Replies
Highlighted
Not applicable

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

Highlighted
Not applicable

Hi Alex,

Try this,

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

View solution in original post

Highlighted
Specialist II
Specialist II

Hi Aleksander,


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


- Regards,


Vishal Waghole

Highlighted
Not applicable

Hi VishalWaghole.

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

Thanks for help anyway!