topic Re: Need help with grouping data while excluding others in App Development https://community.qlik.com/t5/App-Development/Need-help-with-grouping-data-while-excluding-others/m-p/83160#M5516 <HTML><HEAD></HEAD><BODY><P>Please give a snapshot of how the data model looks like?</P></BODY></HTML> Fri, 09 Feb 2018 19:07:07 GMT siddharth_s3 2018-02-09T19:07:07Z Need help with grouping data while excluding others https://community.qlik.com/t5/App-Development/Need-help-with-grouping-data-while-excluding-others/m-p/83159#M5515 <HTML><HEAD></HEAD><BODY><P>I need help in summarizing information based on a product's sales result. Example is below, I need to see how many Nintendo customers buy Xbox products and how many Non-Nintendo customers buy Xbox products, the grouping is based on Nintendo customers. Both Nintendo and Xbox are in the Product field. Thanks.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Products</P><P>Customers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Nintendo&nbsp;&nbsp;&nbsp;&nbsp; Xbox</P><P>Cust 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $10</P><P>Cust 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $15</P><P>Cust 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $15</P><P>Cust 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0</P><P></P><P>Nintendo customers&nbsp;&nbsp; $15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $10</P><P>Non-Nintendo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $30 <SPAN style="color: #000000; font-size: 12pt; font-family: Times New Roman;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Fri, 09 Feb 2018 17:24:33 GMT https://community.qlik.com/t5/App-Development/Need-help-with-grouping-data-while-excluding-others/m-p/83159#M5515 Anonymous 2018-02-09T17:24:33Z Re: Need help with grouping data while excluding others https://community.qlik.com/t5/App-Development/Need-help-with-grouping-data-while-excluding-others/m-p/83160#M5516 <HTML><HEAD></HEAD><BODY><P>Please give a snapshot of how the data model looks like?</P></BODY></HTML> Fri, 09 Feb 2018 19:07:07 GMT https://community.qlik.com/t5/App-Development/Need-help-with-grouping-data-while-excluding-others/m-p/83160#M5516 siddharth_s3 2018-02-09T19:07:07Z Re: Need help with grouping data while excluding others https://community.qlik.com/t5/App-Development/Need-help-with-grouping-data-while-excluding-others/m-p/83161#M5517 <HTML><HEAD></HEAD><BODY><P>Thank you but I think I found a workaround.</P></BODY></HTML> Fri, 09 Feb 2018 20:48:14 GMT https://community.qlik.com/t5/App-Development/Need-help-with-grouping-data-while-excluding-others/m-p/83161#M5517 Anonymous 2018-02-09T20:48:14Z