Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
May be this
{<Customer = p(Customer), Product = e(Product)>}
I tried, but still wont work.
I wrote: sum({<Customer = p(Customer ), Product = e(Product )>}sales)
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?
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
Here is a Qlik Sense sample