topic Re: Listbox to exclude values in App Development

Listbox to exclude values

twanqlik — Fri, 02 Feb 2018 09:57:03 GMT

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

*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 — Fri, 02 Feb 2018 12:53:16 GMT

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

twanqlik — Fri, 02 Feb 2018 13:35:58 GMT

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

sunny_talwar — Fri, 02 Feb 2018 13:40:14 GMT

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

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

petter — Fri, 02 Feb 2018 14:09:18 GMT

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)