Listbox showing items not belonging to the criteria

[#1]

New to qlikview, I would like to ask for help with regards to selection of exclusions.  What kind of expression would satisy this criteria?

1. I have a List of Customers which is linked to a sales transaction table

2.  I filter and select certain criteria on the transaction table and naturally it shows the customers with those transactions

Question:

How can I create a listbox which shows all customers which do not have transactions or exclusion to the selected criteria?

What expression do I use?  Help would be very much appreciated.

[MK_QSL · Accepted solution]

Consider that your have below script..

Load * Inline

[

  Customer, Sales

  A, 100

  B, 200

  C, 140

  E,

];

This will give you list box where customer having sales <> 0.

Type this in Listbox Expression.

=IF(Aggr(SUM(Sales),Customer)>0, Customer)

or

=IF(Aggr(SUM(Sales),Customer)<>0, Customer)

This will give you list box where customer having no sales

=IF(Aggr(SUM(Sales),Customer)=0, Customer)

[#3]

Thanks, this really helped