Multiple Condition (OR)

[#1]

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

[its_anandrjs]

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

[tresesco · Accepted solution]

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

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

[#4]

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.