topic Design Help in QlikView https://community.qlik.com/t5/QlikView/Design-Help/m-p/836415#M294199 <HTML><HEAD></HEAD><BODY><P>I have a data set that is customer by transaction:</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 232px;"><TBODY><TR><TD height="20" width="80">Name</TD><TD width="64">Product</TD><TD width="88">Product Type</TD></TR><TR><TD height="20">Tom Smith</TD><TD>Pizza</TD><TD>Pepperoni</TD></TR><TR><TD height="20">Tom Smith</TD><TD>Sub</TD><TD>Ham</TD></TR><TR><TD height="20">Tom Smith</TD><TD>Burger </TD><TD>Cheese</TD></TR><TR><TD height="20">John Doe</TD><TD>Pizza</TD><TD>Sausage</TD></TR><TR><TD height="20">John Doe</TD><TD>Sub</TD><TD>Turkey</TD></TR><TR><TD height="20">John Doe</TD><TD>Burger </TD><TD>Bacon</TD></TR><TR><TD height="20">Jane Rogers</TD><TD>Pizza</TD><TD>Garlic</TD></TR><TR><TD height="20">Jane Rogers</TD><TD>Sub</TD><TD>Portabello</TD></TR><TR><TD height="20">Jane Rogers</TD><TD>Burger </TD><TD>Double</TD></TR><TR><TD height="20">Bill White</TD><TD>Pizza</TD><TD>Pepperoni</TD></TR><TR><TD height="20">Bill White</TD><TD>Sub</TD><TD>Turkey</TD></TR><TR><TD height="20">Bill White</TD><TD>Burger </TD><TD>Cheese</TD></TR></TBODY></TABLE><P></P><P>I need to create a report that captures the product interaction at a customer level. So, if i want to know interactions for pizza and sub:</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 219px;"><TBODY><TR><TD height="20" width="64">Pizza</TD><TD width="72">Sub</TD><TD width="83"># Customers</TD></TR><TR><TD height="20">Pepperoni</TD><TD>Ham</TD><TD align="right">2</TD></TR><TR><TD height="20">Sausage</TD><TD>Turkey</TD><TD align="right">1</TD></TR><TR><TD height="20">Garlic</TD><TD>Portabello</TD><TD align="right">1</TD></TR></TBODY></TABLE><P></P><P>Any suggestions on application design or query structures?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 16 Jun 2015 21:41:22 GMT 2015-06-16T21:41:22Z Design Help https://community.qlik.com/t5/QlikView/Design-Help/m-p/836415#M294199 <HTML><HEAD></HEAD><BODY><P>I have a data set that is customer by transaction:</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 232px;"><TBODY><TR><TD height="20" width="80">Name</TD><TD width="64">Product</TD><TD width="88">Product Type</TD></TR><TR><TD height="20">Tom Smith</TD><TD>Pizza</TD><TD>Pepperoni</TD></TR><TR><TD height="20">Tom Smith</TD><TD>Sub</TD><TD>Ham</TD></TR><TR><TD height="20">Tom Smith</TD><TD>Burger </TD><TD>Cheese</TD></TR><TR><TD height="20">John Doe</TD><TD>Pizza</TD><TD>Sausage</TD></TR><TR><TD height="20">John Doe</TD><TD>Sub</TD><TD>Turkey</TD></TR><TR><TD height="20">John Doe</TD><TD>Burger </TD><TD>Bacon</TD></TR><TR><TD height="20">Jane Rogers</TD><TD>Pizza</TD><TD>Garlic</TD></TR><TR><TD height="20">Jane Rogers</TD><TD>Sub</TD><TD>Portabello</TD></TR><TR><TD height="20">Jane Rogers</TD><TD>Burger </TD><TD>Double</TD></TR><TR><TD height="20">Bill White</TD><TD>Pizza</TD><TD>Pepperoni</TD></TR><TR><TD height="20">Bill White</TD><TD>Sub</TD><TD>Turkey</TD></TR><TR><TD height="20">Bill White</TD><TD>Burger </TD><TD>Cheese</TD></TR></TBODY></TABLE><P></P><P>I need to create a report that captures the product interaction at a customer level. So, if i want to know interactions for pizza and sub:</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 219px;"><TBODY><TR><TD height="20" width="64">Pizza</TD><TD width="72">Sub</TD><TD width="83"># Customers</TD></TR><TR><TD height="20">Pepperoni</TD><TD>Ham</TD><TD align="right">2</TD></TR><TR><TD height="20">Sausage</TD><TD>Turkey</TD><TD align="right">1</TD></TR><TR><TD height="20">Garlic</TD><TD>Portabello</TD><TD align="right">1</TD></TR></TBODY></TABLE><P></P><P>Any suggestions on application design or query structures?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 16 Jun 2015 21:41:22 GMT https://community.qlik.com/t5/QlikView/Design-Help/m-p/836415#M294199 2015-06-16T21:41:22Z Re: Design Help https://community.qlik.com/t5/QlikView/Design-Help/m-p/836416#M294200 <HTML><HEAD></HEAD><BODY><P>dimensions</P><P>aggr(Only({$ &lt;Product={Pizza}&gt;} [Product Type]), Name)</P><P>aggr(Only({$ &lt;Product={Sub}&gt;} [Product Type]), Name)</P><P></P><P>expression</P><P>count({$ &lt;Product={Pizza,Sub}&gt;} DISTINCT Name)</P></BODY></HTML> Tue, 16 Jun 2015 22:19:10 GMT https://community.qlik.com/t5/QlikView/Design-Help/m-p/836416#M294200 maxgro 2015-06-16T22:19:10Z