Exclude values depending on windows checkboxes

[Sahal]

Hi,

In my right listbox i have a windows checkbox and on the left have a chart.

The same field is on both objects and what i would like to do is when i check the listbox values(names) from the listbox the value of the left chart would be exluded.

So if i would select Aaron Möller, Aaron Torin from the listbox then the chart would exclude those 2 values and only show all the other.

Is this possible to do with out manually right click on the left chart and choose "exlude all values" because that is not what i would like to do.

[sunny_talwar]

Try this as your set analysis within the expression you are using:

{<Name = e(Name)>}

[Gysbert_Wassenaar · Accepted solution]

Change the expression in the left chart to include {<Name=E(Name)>}. So for example count(Name) would become count({<Name=E(Name)>}Name).

[yura_ratu]

Try {1-$}  set analysis in expression

For instance: Sum({1-$} [Sales]). It will exclude current selection from all dataset

[Sahal]

Thank you Guys this is great.

There are different approaches to this and all was helpful.

I will mark the one i used.

Thank you.