13 Replies Latest reply: Nov 27, 2017 3:52 AM by Simone Trabattoni RSS

    Make analysis on the excluded from a selection

    Simone Trabattoni

      Hi community!

      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.

      EDIT: Attached new app modified.