topic Intersection in QlikView https://community.qlik.com/t5/QlikView/Intersection/m-p/252286#M1206236 <HTML><HEAD></HEAD><BODY><P>I have 5 sales groups with separate lists of clients: I would like to derive the clients which overlap, not the additive you get when you click on multiple sales groups. Ideally, I'd like to have a straight table that would list the intersecting clients for any combination of sales groups. How is this done?</P><P></P><P>Thanks in advance,</P><P></P><P>Henry</P></BODY></HTML> Mon, 19 Apr 2010 23:08:10 GMT 2010-04-19T23:08:10Z Intersection https://community.qlik.com/t5/QlikView/Intersection/m-p/252286#M1206236 <HTML><HEAD></HEAD><BODY><P>I have 5 sales groups with separate lists of clients: I would like to derive the clients which overlap, not the additive you get when you click on multiple sales groups. Ideally, I'd like to have a straight table that would list the intersecting clients for any combination of sales groups. How is this done?</P><P></P><P>Thanks in advance,</P><P></P><P>Henry</P></BODY></HTML> Mon, 19 Apr 2010 23:08:10 GMT https://community.qlik.com/t5/QlikView/Intersection/m-p/252286#M1206236 2010-04-19T23:08:10Z Intersection https://community.qlik.com/t5/QlikView/Intersection/m-p/252287#M1206238 <HTML><HEAD></HEAD><BODY><P>Hi Henry,</P><P>Concatenate the 5 groups &amp; customer into one single table.</P><P>Pls find the attached application for your reference.</P><P>Regards</P><P>Rajesh</P></BODY></HTML> Tue, 20 Apr 2010 02:15:02 GMT https://community.qlik.com/t5/QlikView/Intersection/m-p/252287#M1206238 2010-04-20T02:15:02Z