Today I'm investigating about the selections in an app.
The goal is to have a kind of analysis on excluded values.
Qlik Sense tells us everything about the selected items in a viz, but (it is my limit clearly) I cannot make it to tell me something about the excluded values.
I'm bringing an example.
I'm working on a group of products, sold (or not) in places, and each places belongs to a brand (brandoftheplace).
I can see that product 3, for example, is sold only in the 25% of the places. To see which places are not selling 3 is very simple, thanks to the power of grey, i.e. the dark grey places are not selling the product 3.
But I cannot see to which brandoftheplace the excluded 75% of the places belong, each one (clearly in this example is rather simple, but let's think in bigger contexts).
So the question is: how can I analyze (in this case find the brandoftheplace) the excluded values? Maybe a table that makes me see only the excluded? If so, how?
I do not know it's clear, but I'm attaching an app with all the data, viz and other things, hoping it helps.
Thanks in avance
EDIT: Attached app with something added after some hints.
I have added a sheet that I think does something like you are looking for to your sample (attached). This will show a table when you pick a particular product that contains only the places where that product is not sold.
I am using the measure below which will show 1 if the selected product is not sold in that place:
I've tried some of your ideas. I'm quite near the result, but as you can see in the app attached and refreshed, I have some problems: the un-selected item is not in the same line of the selected one, and this makes it not visualized when the product is choosen. In the second sheet of the app you can find what I mean.
I've attached a refreshed app with your hints and Bill's one. There is a problem, the excluded value is not in the same line of the product, and this influences the selections. Any idea how to put them in the same line (that is not simply an above() ) function) ? Here the formulae whom work (more or less):