topic Re: "IF (OR..." conditional statement in QlikView

"IF (OR..." conditional statement

Tue, 18 Mar 2014 11:56:56 GMT

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.

MK_QSL — Tue, 18 Mar 2014 11:59:07 GMT

Try something like below.

IF(FieldA = 'Value1' or FieldA = 'Value2',"Value 1,2", "NotValue1,2"

IF(FieldA = 'Value1' or FieldA = 'Value2','Value 1,2', 'NotValue1,2')

kumarnatarajan — Tue, 18 Mar 2014 11:59:15 GMT

Hi,

Try below one

Ex:

Aggr(if(wildmatch(FieldA,'Value1', 'Value2'),'Value 1,2', 'NotValue1,2'),FieldA)

jsingh71 — Tue, 18 Mar 2014 11:59:58 GMT

use this

if(FieldA='Value1' or FieldA='Value2', 'Value1,2', 'NotValue1,2')

kumarnatarajan — Tue, 18 Mar 2014 12:04:11 GMT

=Aggr(if(wildmatch(FieldName,'Value1','Value2'),'Value 1,2', 'NotValue1,2'),FieldName)

Tue, 18 Mar 2014 12:10:18 GMT

Thank you Kumar, I am using this but it looks like the portion after the OR group is giving errors

>> ,"Value 1,2", "NotValue1,2"),FieldA) <<

jsingh71 — Tue, 18 Mar 2014 12:16:18 GMT

can you share your full expression then it will easy to understand where you are getting the error?

MK_QSL — Tue, 18 Mar 2014 12:17:10 GMT

I think this is the same answer i have given ....

jsingh71 — Tue, 18 Mar 2014 12:20:54 GMT

Will start typing at the same time but by fraction of second you posted before me.

MK_QSL — Tue, 18 Mar 2014 12:23:29 GMT

Today is your lucky day.. !

Bill_Britt — Tue, 18 Mar 2014 12:55:54 GMT

Hi,

Take a look at this.