Show column if one or more specific values are selected.

[janus2021]

Hi.
I want to use 'show column' in Diagram: Table
but only if certain choices are made, for example when you have chosen in 'Causes' one or more
of the values: 'stopped', 'Try something else', 'Study leave'.
if you choose another value ex 'sick','leaving' etc, the column should be hidden.

code I wrote under "Show column if" to show the column or hide:
Match (GetFieldSelections ([Causes]), 'stopped', 'Try something else', 'Study leave')
and also with
if(GetSelectedCount(Match(GetFieldSelections([Causes]), 'stopped', 'Try something else', 'Study leave'))>0,1,0)
but nothing has worked.

It works if you only take a value like: [Causes] = 'stopped'.

Tips on how to do.

[janus2021]

no one has any tips on solution?

[janus2021 · Accepted solution]

This solved my problem, mayby not the best solution but it solved my problem.

I wrote this under "Show column if": if(wildmatch(getfieldselections([Causes]), ’stoppe*',' Try*',' Study*'), 1, 0)