Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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