Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Counting a Count

PersonVisit
Emily

1/1/16

Emily2/1/16
Sal1/15/16
Sue2/15/16
Sue2/16/16

I want to be able to count the number of People if the visit count per person is greater than 1.  So in the above table, my answer would be 2.  I would count Emily and Sue, but not Sal.   

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try as expression e.g. in a text box

=Count({<Person = {"=Count(Visit)>1"}>} DISTINCT Person)

View solution in original post

2 Replies
swuehl
MVP
MVP

Try as expression e.g. in a text box

=Count({<Person = {"=Count(Visit)>1"}>} DISTINCT Person)

Not applicable
Author

Thank you, that worked perfectly!