topic Re: Exclude values depending on windows checkboxes in QlikView

Exclude values depending on windows checkboxes

Sahal — Thu, 04 Feb 2016 10:07:10 GMT

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.

Re: Exclude values depending on windows checkboxes

sunny_talwar — Thu, 04 Feb 2016 17:30:36 GMT

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

{<Name = e(Name)>}

Re: Exclude values depending on windows checkboxes

Gysbert_Wassenaar — Thu, 04 Feb 2016 17:31:50 GMT

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

Re: Exclude values depending on windows checkboxes

yura_ratu — Thu, 04 Feb 2016 17:34:09 GMT

Try {1-$} set analysis in expression

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

Re: Exclude values depending on windows checkboxes

Sahal — Fri, 05 Feb 2016 08:31:01 GMT

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.