1 Reply Latest reply: Jun 7, 2017 3:07 PM by Felip Drechsler RSS

    Cryptic Error message when creating a Calculated Dimension

    Rishabh Sinha



      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.