Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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!