topic Crosselling in QlikView https://community.qlik.com/t5/QlikView/Crosselling/m-p/858045#M1016810 <HTML><HEAD></HEAD><BODY><P>Hi experts</P><P></P><P>i am creating a crosselling in qlikview and i have a problem</P><P></P><P>the data is distribute in one table and one client could have more than one product</P><P></P><P>Client&nbsp;&nbsp;&nbsp;&nbsp; Producto</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P></P><P>the crosselling works ok, but if i have and do some kind of filtres such as:</P><P></P><P>See clients that have product 1 but NOT HAVE product 2, do not works ok and looks like my solution do not work</P><P></P><P>attached and image to get the example</P><P></P><P>i have trie with the AND MODE and the list panel work like that,</P><P></P><P>thank you a lot</P><P></P><P>what do you think could be a would solution?</P></BODY></HTML> Fri, 17 Apr 2015 15:04:07 GMT fkeuroglian 2015-04-17T15:04:07Z Crosselling https://community.qlik.com/t5/QlikView/Crosselling/m-p/858045#M1016810 <HTML><HEAD></HEAD><BODY><P>Hi experts</P><P></P><P>i am creating a crosselling in qlikview and i have a problem</P><P></P><P>the data is distribute in one table and one client could have more than one product</P><P></P><P>Client&nbsp;&nbsp;&nbsp;&nbsp; Producto</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P></P><P>the crosselling works ok, but if i have and do some kind of filtres such as:</P><P></P><P>See clients that have product 1 but NOT HAVE product 2, do not works ok and looks like my solution do not work</P><P></P><P>attached and image to get the example</P><P></P><P>i have trie with the AND MODE and the list panel work like that,</P><P></P><P>thank you a lot</P><P></P><P>what do you think could be a would solution?</P></BODY></HTML> Fri, 17 Apr 2015 15:04:07 GMT https://community.qlik.com/t5/QlikView/Crosselling/m-p/858045#M1016810 fkeuroglian 2015-04-17T15:04:07Z Re: Crosselling https://community.qlik.com/t5/QlikView/Crosselling/m-p/858046#M1016811 <HTML><HEAD></HEAD><BODY><P>The and-mode is one possibility but needs some requirements <A href="https://community.qlik.com/qlik-blogpost/3219">AND-Mode</A> / <A href="https://community.qlik.com/qlik-blogpost/3618">AND and OR</A> and another approach could be a set analysis expression, maybe like this one:</P><P></P><P>sum({&lt; Products = {'product1'}, Products -= {'product2'}&gt;} value)</P><P></P><P>- Marcus</P></BODY></HTML> Sat, 18 Apr 2015 16:06:17 GMT https://community.qlik.com/t5/QlikView/Crosselling/m-p/858046#M1016811 marcus_sommer 2015-04-18T16:06:17Z