Set Analysis exclude selection help

[castro88]

Hi to all,

I'm new to QlikSense and I have a little problem in writing a set analysis.

What I'm trying to do is write a set analysis inside a pivot table (as a measure), which displays the sales of all the products of the customers, excluding the products selected by the user.

In my pivot table I have Product and Costumer as a dimension.

Can someone explain how to do it?

Thanks!!!

[sunny_talwar]

May be this

{<Customer = p(Customer), Product = e(Product)>}

[castro88]

I tried, but still wont work.

I wrote: sum({<Customer = p(Customer ), Product = e(Product )>}sales)

[sunny_talwar]

With selection in a product, it seems to work for me

Where the raw data looked like this

So, we are seeing Customer A  because he is associated with the Product and we are seeing all products except the selected one... is this not what you wanted?

[castro88]

what you showed me is what I want, but I do not know why on QlikSense it does not seem to work.

Anyway thanks for the answer

[sunny_talwar]

Here is a Qlik Sense sample