Listbox to exclude values

[twanqlik]

Instead of using a listbox to select values that need to be included, I want to use a listbox to exclude values.

Example with using the below table.

Selection 1: User selects 'Campaign Business Group = PC'

Selection 2: User selects 'Variable = Vita'  to exclude Vita.

End result: The user expects to see only: Campaign.ID= 1,2,4,5

Campaign.ID	Campaign Business Group	Variable
1	PC
2	PC	Test
3	PC	Vita
4	PC	Nutri
5	PC
6	PC
7	HCC
8	HCC
9	HCC

*Any thoughts on how to do this?

Even nicer would be to have a variable that i can use to make the listbox an include or exclude list

[sunny_talwar]

Is this something you need for a chart or dashboard wide?

[twanqlik]

Preferable dashboard wide, but when that is not possible, for a chart can also work.

[sunny_talwar]

Chart should be simple... you can use e() to exclude selection in an expression using set analysis

P() & E() and where do you use them?

Dashboard wide could become difficult to maintain, but should be possible using triggers

[petter]

An expression like this could be used:

MinString({1-<Variable={$(=GetFieldSelections(Variable))}>} Variable)

If you want to do it application / dashboard wide you can make the set expression into a variable and use it in all charts that need it:

vExclude = '1-<Variable={$(=GetFieldSelections(Variable))}>'

MinString({$(vExclude} Variable)