topic Re: Filter for customers without orders in QlikView

Filter for customers without orders

Tue, 07 Jun 2016 18:26:13 GMT

Each week we load orders in the dashboard. Weekly uploads are date stamped.

Not all customers will have orders each week but we would like to setup a filter

Customers with orders
Yes
No

We tried doing this in the script but the customer list is static so we cannot append a count or "Has orders" field because if we want to see a different week, the filter will change.

Re: Filter for customers without orders

sunny_talwar — Tue, 07 Jun 2016 18:44:00 GMT

Can you provide some raw data and how you plan to use this filter?

Re: Filter for customers without orders

swuehl — Tue, 07 Jun 2016 18:51:33 GMT

Try a list box with a field expression (select <expression> from the field drop down list on general tab) like

=Aggr( If(Count(OrderID)>0,'Yes','No'), CustomerID)

Re: Filter for customers without orders

Tue, 07 Jun 2016 19:59:12 GMT

I figured aggr would have to show up. I used the expression but only now realized the expression effectively filters itself. If I select Yes, No disappears and select No, Yes disappears.

Re: Filter for customers without orders

swuehl — Tue, 07 Jun 2016 20:09:17 GMT

=Aggr( If(Count({<CustomerID= >}OrderID)>0,'Yes','No'), CustomerID)

Re: Filter for customers without orders

Tue, 07 Jun 2016 20:19:27 GMT

Forgot about that clause. Very nice - many thanks.