Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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!