"IF (OR..." conditional statement

[#1]

Hi everyone,

I'm trying to create a calculated dimension using an "if(or..." conditional expression.

The statement is: IF(OR(FieldA = 'Value1', FieldA = 'Value2'),"Value 1,2", "NotValue1,2")

But I get errors. I'm using typical Excel conditional formatting syntax, assuming this would apply.

My objective is to get two cases: a) Value 1,2 and b) NotValue 1,2

and then use these in a pivot table to show summary results.

[Bill_Britt]

Hi,

Take a look at this.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/17/and-or