Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Listbox showing items not belonging to the criteria

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.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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)

View solution in original post

2 Replies
MK_QSL
MVP
MVP

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)

Not applicable
Author

Thanks, this really helped