Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Cryptic Error message when creating a Calculated Dimension

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.

1 Solution

Accepted Solutions
felipedl
Valued Contributor III

Re: Cryptic Error message when creating a Calculated Dimension

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.

1 Reply
felipedl
Valued Contributor III

Re: Cryptic Error message when creating a Calculated Dimension

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.