topic Re: And Operator in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/And-Operator-in-Set-Analysis/m-p/336486#M492271 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P><EM>=count({&lt;[Employee ID] = p({&lt;[Course Name] = {Course1}&gt;}) * p({&lt;[Course Name] = {Course2}&gt;}) &gt;} distinct [Employee ID])</EM></P></BODY></HTML> Thu, 05 Jul 2012 15:51:18 GMT swuehl 2012-07-05T15:51:18Z And Operator in Set Analysis https://community.qlik.com/t5/QlikView/And-Operator-in-Set-Analysis/m-p/336485#M492270 <HTML><HEAD></HEAD><BODY><P>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.</P><P>Count({&lt;[Course Name] = {'Course1', 'Course2'}&gt;} Distinct [Employee ID])</P><P>gives me a count of the employees who have taken either course. I want only those who have taken both courses.</P></BODY></HTML> Thu, 05 Jul 2012 15:47:17 GMT https://community.qlik.com/t5/QlikView/And-Operator-in-Set-Analysis/m-p/336485#M492270 Anonymous 2012-07-05T15:47:17Z Re: And Operator in Set Analysis https://community.qlik.com/t5/QlikView/And-Operator-in-Set-Analysis/m-p/336486#M492271 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P><EM>=count({&lt;[Employee ID] = p({&lt;[Course Name] = {Course1}&gt;}) * p({&lt;[Course Name] = {Course2}&gt;}) &gt;} distinct [Employee ID])</EM></P></BODY></HTML> Thu, 05 Jul 2012 15:51:18 GMT https://community.qlik.com/t5/QlikView/And-Operator-in-Set-Analysis/m-p/336486#M492271 swuehl 2012-07-05T15:51:18Z