Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

List Box - Condition

Hello Community!

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)?

Thank you for any assistance!

2 Replies
Highlighted
Employee
Employee

Change the list box 'field' to be an expression and enter something like this:

=if( aggr(sum(Sales)>0,Customer) , Customer)

Highlighted
MVP
MVP

maybe with an expression in listbox

=if(aggr(count(%Fact_Key ),company)>0,company)