Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
if(FieldA='Value1' or FieldA='Value2', 'Value1,2', 'NotValue1,2')
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')
Try below one
Aggr(if(wildmatch(FieldA,'Value1', 'Value2'),'Value 1,2', 'NotValue1,2'),FieldA)
=Aggr(if(wildmatch(FieldName,'Value1','Value2'),'Value 1,2', 'NotValue1,2'),FieldName)
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) <<
can you share your full expression then it will easy to understand where you are getting the error?
I think this is the same answer i have given ....
Will start typing at the same time but by fraction of second you posted before me.
Today is your lucky day.. !