Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jimthomlinson
Contributor III
Contributor III

And Operator in Set Analysis

Is there and and operator in Set Analysis. For example I want a count of all of the people who took both Course1 and Course2.

Count({<[Course Name] = {'Course1', 'Course2'}>} Distinct [Employee ID])

gives me a count of the employees who have taken either course. I want only those who have taken both courses.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

=count({<[Employee ID] = p({<[Course Name] = {Course1}>}) * p({<[Course Name] = {Course2}>}) >} distinct [Employee ID])

View solution in original post

1 Reply
swuehl
MVP
MVP

Try

=count({<[Employee ID] = p({<[Course Name] = {Course1}>}) * p({<[Course Name] = {Course2}>}) >} distinct [Employee ID])

View solution in original post