topic Show excluded data in QlikView

Show excluded data

Mon, 15 Feb 2010 12:55:34 GMT

Hi all.

I have 3 tables:
- Customers
ABC,
Nasa,
T-Airlines
- Products
Laptop,
PC,
Mouse
- Sales

In a listbox i want to select one Product, and the result should be a tablebox with the Customers who don't buyed this selected Product.

In Sales (Customer, Product, Quantity) i have the following records:
ABC, Laptop, 1
Nasa, Mouse, 2

So I select "Mouse" and the content of my tablebox should be:
ABC
T-Airlines

Is this possible?
Maybe someone could help me....

Thanks
Ivo.

Mon, 15 Feb 2010 13:22:08 GMT

I think u can use set analysis in order to achieve this

count({1-$} Customer)

Use this expression in straight table and then hide that expression so that tere is only one field Customer

Mon, 15 Feb 2010 16:34:41 GMT

Create the following expression in your table


=sum({1-$} Sales)

Returns sales for everything excluded by the current selection.

Tue, 16 Feb 2010 08:26:28 GMT

This is what I was looking for.

Thanks a lot.
Ivo.