Cryptic Error message when creating a Calculated Dimension

[#1]

Hi,

I'm new to QlikSense and am exploring the capabilities of the tool for a POC. I've loaded data in the Data Manager and I'm trying to create a calculated field using the following expression:

If(Match(Left(FromBIC,4),'ABCD') and Match(Left(ToBIC,4),'ABCD'),'B',If(Match(Direction, 'O'), 'I', 'O'))

However, I get the error that I'm missing right parenthesis.

Could you help me identify the root cause of the error?

Assume that the "FromBIC", "ToBIC" and "Direction" are fields that are present in the source file.

[felipedl · Accepted solution]

Hi Rishabh,

I created the attahed QVF file with some dummy data and your expression works fine for me.

Maybe your missing the right parenthesis on the one you inputed on your graph.

Can you share your QVF file to see if somethings up?

Regards,

Felipe.