topic expression to exclude customers in App Development https://community.qlik.com/t5/App-Development/expression-to-exclude-customers/m-p/1086701#M18102 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>each customer has a Customer ID.</P><P></P><P>I have a stacked bar chart with a written expression to count the number of orders from each department</P><P></P><P>e.g Catering, Homeware, Children.</P><P></P><P>however I want to count the customer ID's that have ordered from Children, and other departments.... on the bar chart I want to exclude the customerIDs that have only ever ordered from Children department</P><P></P><P>please help</P></BODY></HTML> Tue, 29 Mar 2016 09:33:49 GMT joeybird 2016-03-29T09:33:49Z expression to exclude customers https://community.qlik.com/t5/App-Development/expression-to-exclude-customers/m-p/1086701#M18102 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>each customer has a Customer ID.</P><P></P><P>I have a stacked bar chart with a written expression to count the number of orders from each department</P><P></P><P>e.g Catering, Homeware, Children.</P><P></P><P>however I want to count the customer ID's that have ordered from Children, and other departments.... on the bar chart I want to exclude the customerIDs that have only ever ordered from Children department</P><P></P><P>please help</P></BODY></HTML> Tue, 29 Mar 2016 09:33:49 GMT https://community.qlik.com/t5/App-Development/expression-to-exclude-customers/m-p/1086701#M18102 joeybird 2016-03-29T09:33:49Z Re: expression to exclude customers https://community.qlik.com/t5/App-Development/expression-to-exclude-customers/m-p/1086702#M18103 <HTML><HEAD></HEAD><BODY><P>chk it</P><P><A href="https://community.qlik.com/qlik-blogpost/4424">Excluding values in Set Analysis</A></P></BODY></HTML> Tue, 29 Mar 2016 09:35:29 GMT https://community.qlik.com/t5/App-Development/expression-to-exclude-customers/m-p/1086702#M18103 Chanty4u 2016-03-29T09:35:29Z Re: expression to exclude customers https://community.qlik.com/t5/App-Development/expression-to-exclude-customers/m-p/1086703#M18104 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>Count(<STRONG>{&lt;CustomerID -= {"=ONLY(Department)='Children' "}&gt;}</STRONG> DISTINCT CustomerID)</P><P></P><P>Note the minus sign before the equal sign,</P></BODY></HTML> Tue, 29 Mar 2016 09:50:26 GMT https://community.qlik.com/t5/App-Development/expression-to-exclude-customers/m-p/1086703#M18104 swuehl 2016-03-29T09:50:26Z Re: expression to exclude customers https://community.qlik.com/t5/App-Development/expression-to-exclude-customers/m-p/1086704#M18105 <HTML><HEAD></HEAD><BODY><P>brill thank you x</P></BODY></HTML> Tue, 29 Mar 2016 10:36:15 GMT https://community.qlik.com/t5/App-Development/expression-to-exclude-customers/m-p/1086704#M18105 joeybird 2016-03-29T10:36:15Z