Check if value is in a listbox

Mon, 31 Mar 2014 15:12:57 GMT

Hi!

I have a ListBox with values:

value1

value2

value3

....

I have a chart with many expression:

exp1 is show when value1 is cheked

exp2 is show when value2 is cheked

exp2 is show when value3 is cheked

everything works when I have only 1 value checked in the listbox, but when there is more then 1 value checked the chart is empty.

I would like that if I check value1 and value2, exp1 and exp2 are shown

as Conditional expression (for expX) I use

- ListBox='valueX'

- =if(match(GetFieldSelections(ListBox),'valueX'),1,0)

- =count({<ListBox = {'ValueX'}>} valueX)

but all of them give me the same problem....

Some Idea?

Re: Check if value is in a listbox

Gysbert_Wassenaar — Mon, 31 Mar 2014 15:18:03 GMT

Try =if(maxstring({<ListBox*={'ValueX'}>}ListBox)='ValueX',1,0)

Wed, 02 Apr 2014 13:06:25 GMT

Perfect! thank u very much!