topic Re: Count non selected in QlikView https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086456#M941102 <HTML><HEAD></HEAD><BODY><P>You need to clear selections in Product, too:</P><P>Count({&lt;Customer =e(), Product=&gt;} TOTAL DISTINCT Customer)</P><P></P><P>see also attached</P></BODY></HTML> Wed, 27 Jan 2016 21:18:33 GMT swuehl 2016-01-27T21:18:33Z Count non selected https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086450#M941096 <HTML><HEAD></HEAD><BODY><P>My tables consists of:</P><P></P><P>Customer&nbsp;&nbsp;&nbsp;&nbsp; Product&nbsp;&nbsp;&nbsp;&nbsp; Sales £</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.00</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.00</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.00</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.00</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.00</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.00</P><P></P><P>I would like to use a list box to select a product and then create a table like below so I can see how many are buying and how many are not:</P><P></P><P>If product X selected</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Qty customers&nbsp;&nbsp;&nbsp;&nbsp; Qty customers</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; buying&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; not buying</P><P>X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P></P><P></P><P>If product Z selected</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Qty customers&nbsp;&nbsp;&nbsp;&nbsp; Qty customers</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; buying&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; not buying</P><P>Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P></BODY></HTML> Wed, 27 Jan 2016 19:50:53 GMT https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086450#M941096 2016-01-27T19:50:53Z Re: Count non selected https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086451#M941097 <HTML><HEAD></HEAD><BODY><P>Create a straight table chart with dimension Product and two expressions:</P><P></P><P>=Count(DISTINCT Customer)</P><P></P><P>=Count({&lt;Customer =e()&gt;} TOTAL DISTINCT Customer)</P></BODY></HTML> Wed, 27 Jan 2016 20:14:37 GMT https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086451#M941097 swuehl 2016-01-27T20:14:37Z Re: Count non selected https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086452#M941098 <HTML><HEAD></HEAD><BODY><P>Z seems to be bought by 2 customers also. A and C? Isn't it?</P></BODY></HTML> Wed, 27 Jan 2016 20:15:08 GMT https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086452#M941098 sunny_talwar 2016-01-27T20:15:08Z Re: Count non selected https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086453#M941099 <HTML><HEAD></HEAD><BODY><P>Hi swuel</P><P>The latter formula is not accepted. Is there a syntax error in it ?</P></BODY></HTML> Wed, 27 Jan 2016 20:54:59 GMT https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086453#M941099 2016-01-27T20:54:59Z Re: Count non selected https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086454#M941100 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny T. Now corrected.</P></BODY></HTML> Wed, 27 Jan 2016 21:10:37 GMT https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086454#M941100 2016-01-27T21:10:37Z Re: Count non selected https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086455#M941101 <HTML><HEAD></HEAD><BODY><P>Is it just highlighted by the syntax checker, or is there no result shown in the table?</P></BODY></HTML> Wed, 27 Jan 2016 21:11:59 GMT https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086455#M941101 swuehl 2016-01-27T21:11:59Z Re: Count non selected https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086456#M941102 <HTML><HEAD></HEAD><BODY><P>You need to clear selections in Product, too:</P><P>Count({&lt;Customer =e(), Product=&gt;} TOTAL DISTINCT Customer)</P><P></P><P>see also attached</P></BODY></HTML> Wed, 27 Jan 2016 21:18:33 GMT https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086456#M941102 swuehl 2016-01-27T21:18:33Z Re: Count non selected https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086457#M941103 <HTML><HEAD></HEAD><BODY><P>This should also work for you.</P><P></P><P><STRONG>Count({&lt;Product&gt;}TOTAL DISTINCT Customer) - Count(DISTINCT Customer)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112729_Capture.PNG" style="height: 104px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Wed, 27 Jan 2016 21:23:38 GMT https://community.qlik.com/t5/QlikView/Count-non-selected/m-p/1086457#M941103 sunny_talwar 2016-01-27T21:23:38Z