topic Re: Multiple Condition (OR) in QlikView

Multiple Condition (OR)

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have an a chart with an expression that should be enabled depending on the selection of the user. I have created the condition but only the first part works and not the second (after the OR):

Condition:

Subfield(Variable1, '|',2) <> 'Apple' OR Subfield(Variable1, '|',6)<>'Clothes'

When I select "apple" the column in the chart disappears but when I select "Clothes" it does not.

What am I doing wrong?

Thanks for your help

Re: Multiple Condition (OR)

its_anandrjs — Fri, 04 Nov 2016 10:13:18 GMT

Can you share sample file for the same also why subfield have 2 and 6 in the condition.

Subfield(Variable1, '|',2) <> 'Apple' OR Subfield(Variable1, '|',6)<>'Clothes'

Regards

Anand

Re: Multiple Condition (OR)

tresB — Fri, 04 Nov 2016 10:32:51 GMT

You perhaps need 'AND' rather than 'OR'.

Subfield(Variable1, '|',2) <> 'Apple' AND Subfield(Variable1, '|',6)<>'Clothes'

Re: Multiple Condition (OR)

Fri, 04 Nov 2016 10:40:04 GMT

You are right.

I guess I was wrong in my assumption. Because by placing an "AND" I thought that in order to the expression to be disable I would need to choose both Apple and Clothes, thats why I went for "OR". But with AND is work as expected. Thanks for the tip.