Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

castro88
New Contributor

Set Analysis exclude selection help

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!!!

5 Replies
MVP
MVP

Re: Set Analysis help

May be this

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

castro88
New Contributor

Re: Set Analysis help

I tried, but still wont work.

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

MVP
MVP

Re: Set Analysis help

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

Capture.PNG

Where the raw data looked like this

Capture.PNG

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
New Contributor

Re: Set Analysis exclude selection help

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

MVP
MVP

Re: Set Analysis exclude selection help

Here is a Qlik Sense sample

Capture.PNG