topic Re: List Box - Condition in QlikView https://community.qlik.com/t5/QlikView/List-Box-Condition/m-p/713724#M256877 <HTML><HEAD></HEAD><BODY><P>Change the list box 'field' to be an expression and enter something like this:</P><P></P><P>=if( aggr(sum(Sales)&gt;0,Customer) , Customer)</P></BODY></HTML> Thu, 04 Sep 2014 19:51:47 GMT JonnyPoole 2014-09-04T19:51:47Z List Box - Condition https://community.qlik.com/t5/QlikView/List-Box-Condition/m-p/713723#M256876 <HTML><HEAD></HEAD><BODY><P>Hello Community!</P><P></P><P>How do you add a list box that shows ONLY the company names that are associated with sales/orders (i.e. %Fact_Key is not null)?</P><P></P><P>Thank you for any assistance!</P></BODY></HTML> Thu, 04 Sep 2014 19:48:53 GMT https://community.qlik.com/t5/QlikView/List-Box-Condition/m-p/713723#M256876 2014-09-04T19:48:53Z Re: List Box - Condition https://community.qlik.com/t5/QlikView/List-Box-Condition/m-p/713724#M256877 <HTML><HEAD></HEAD><BODY><P>Change the list box 'field' to be an expression and enter something like this:</P><P></P><P>=if( aggr(sum(Sales)&gt;0,Customer) , Customer)</P></BODY></HTML> Thu, 04 Sep 2014 19:51:47 GMT https://community.qlik.com/t5/QlikView/List-Box-Condition/m-p/713724#M256877 JonnyPoole 2014-09-04T19:51:47Z Re: List Box - Condition https://community.qlik.com/t5/QlikView/List-Box-Condition/m-p/713725#M256878 <HTML><HEAD></HEAD><BODY><P>maybe with an expression in listbox</P><P></P><P>=if(aggr(count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">%Fact_Key </SPAN>),company)&gt;0,company)</P></BODY></HTML> Thu, 04 Sep 2014 19:54:58 GMT https://community.qlik.com/t5/QlikView/List-Box-Condition/m-p/713725#M256878 maxgro 2014-09-04T19:54:58Z