topic Re: Conditional IF statement to show / hide expressions in QlikView

Conditional IF statement to show / hide expressions

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Conditional IF statement to show / hide expressions

ychaitanya — Fri, 02 Mar 2018 16:07:29 GMT

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)

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

Re: Conditional IF statement to show / hide expressions

sunny_talwar — Fri, 02 Mar 2018 16:10:45 GMT

Something like this

Used this

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

Re: Conditional IF statement to show / hide expressions

hopkinsc — Fri, 02 Mar 2018 16:28:22 GMT

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

Re: Conditional IF statement to show / hide expressions

sunny_talwar — Fri, 02 Mar 2018 16:29:15 GMT

May be this

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