Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!