Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Listbox showing items not belonging to the criteria

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)

2 Replies

Re: Listbox showing items not belonging to the criteria

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

Re: Listbox showing items not belonging to the criteria

Thanks, this really helped

Community Browser