Conditional IF statement to show / hide expressions

[hopkinsc]

Hi all

i have a straight table with 10 expressions, the users want to be able to select which columns they want to view so i have created an inline table with the column names and i am using it in a list box set as LED checkboxes.

i then have a conditional show on each expression..

if(Field = 'ColumnA',1,0)

changing the value for each conditional expression.

obviously this doesn't work if multiple values are selected in the inline field.

does anyone know how i can achieve this please?

sample attached

[ychaitanya]

Hello

You could try

matching multiple ways for the 10 different expressions

SubStringCount(Concat(Field, '|'), '1')

The second won't work without an if:

=if(SubStringCount(Concat(Field, '|'), 'Exprname')>1,1,0)

OR

WILDMATCH(Concat(distinct FIELD),'*Expr Name*')>0

[sunny_talwar]

Something like this

Used this

SubStringCount(Concat(DISTINCT '|' & Column & '|'), '|A|') = 1

[hopkinsc]

Hi Sunny,

if none are selected, how do i get it to not show any of the expressions?

at the moment it shows all if none are selected

[sunny_talwar · Accepted solution]

May be this

SubStringCount(Concat(DISTINCT '|' & Column & '|'), '|A|') = 1 and GetSelectedCount(Column) >= 1