topic Count If In Dimension Expression in QlikView https://community.qlik.com/t5/QlikView/Count-If-In-Dimension-Expression/m-p/959774#M953152 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">I want to show a list box showing only customers who have open sales lines, my expression is :</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">If(<SPAN style="color: #0000ff;">Count</SPAN> (<SPAN style="color: #0000ff;">Total</SPAN> <SPAN style="color: #800000;">Order_Number</SPAN>)&gt;0,<SPAN style="color: #800000;">Customer</SPAN>) </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">However this wont work, any pointers?</SPAN></P></BODY></HTML> Mon, 23 Nov 2015 09:18:27 GMT dmac1971 2015-11-23T09:18:27Z Count If In Dimension Expression https://community.qlik.com/t5/QlikView/Count-If-In-Dimension-Expression/m-p/959774#M953152 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">I want to show a list box showing only customers who have open sales lines, my expression is :</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">If(<SPAN style="color: #0000ff;">Count</SPAN> (<SPAN style="color: #0000ff;">Total</SPAN> <SPAN style="color: #800000;">Order_Number</SPAN>)&gt;0,<SPAN style="color: #800000;">Customer</SPAN>) </SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">However this wont work, any pointers?</SPAN></P></BODY></HTML> Mon, 23 Nov 2015 09:18:27 GMT https://community.qlik.com/t5/QlikView/Count-If-In-Dimension-Expression/m-p/959774#M953152 dmac1971 2015-11-23T09:18:27Z Re: Count If In Dimension Expression https://community.qlik.com/t5/QlikView/Count-If-In-Dimension-Expression/m-p/959775#M953153 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">If(<SPAN style="color: #0000ff;">Count</SPAN> (only(<SPAN style="color: #0000ff;">Total</SPAN> <SPAN style="color: #800000;">Order_Number</SPAN>)&gt;0,<SPAN style="color: #800000;">Customer</SPAN>)) <BR /></SPAN></P></BODY></HTML> Mon, 23 Nov 2015 09:21:59 GMT https://community.qlik.com/t5/QlikView/Count-If-In-Dimension-Expression/m-p/959775#M953153 Chanty4u 2015-11-23T09:21:59Z Re: Count If In Dimension Expression https://community.qlik.com/t5/QlikView/Count-If-In-Dimension-Expression/m-p/959776#M953154 <HTML><HEAD></HEAD><BODY><P>Sorry doesn't work, empty table.</P></BODY></HTML> Mon, 23 Nov 2015 09:25:44 GMT https://community.qlik.com/t5/QlikView/Count-If-In-Dimension-Expression/m-p/959776#M953154 dmac1971 2015-11-23T09:25:44Z Re: Count If In Dimension Expression https://community.qlik.com/t5/QlikView/Count-If-In-Dimension-Expression/m-p/959777#M953155 <HTML><HEAD></HEAD><BODY><P>You need to wrap your condition within an aggr-function: aggr(count(Order_Number)&gt;0, Customer)</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 23 Nov 2015 09:26:29 GMT https://community.qlik.com/t5/QlikView/Count-If-In-Dimension-Expression/m-p/959777#M953155 marcus_sommer 2015-11-23T09:26:29Z Re: Count If In Dimension Expression https://community.qlik.com/t5/QlikView/Count-If-In-Dimension-Expression/m-p/959778#M953156 <HTML><HEAD></HEAD><BODY><P>That sorted it Marcus, many thanks :</P><P></P><P><SPAN style="font-size: 10pt;">if( <SPAN style="color: #0000ff;">aggr</SPAN>(<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">Order_Number</SPAN>), <SPAN style="color: #800000;">Customer</SPAN>)&gt;0,<SPAN style="color: #800000;">Customer</SPAN>) </SPAN></P></BODY></HTML> Mon, 23 Nov 2015 09:31:42 GMT https://community.qlik.com/t5/QlikView/Count-If-In-Dimension-Expression/m-p/959778#M953156 dmac1971 2015-11-23T09:31:42Z