topic Re: Cryptic Error message when creating a Calculated Dimension in App Development https://community.qlik.com/t5/App-Development/Cryptic-Error-message-when-creating-a-Calculated-Dimension/m-p/1323603#M28626 <HTML><HEAD></HEAD><BODY><P>Hi Rishabh,</P><P></P><P>I created the attahed QVF file with some dummy data and your expression works fine for me.</P><P>Maybe your missing the right parenthesis on the one you inputed on your graph.</P><P>Can you share your QVF file to see if somethings up?</P><P></P><P>Regards,</P><P></P><P>Felipe.</P></BODY></HTML> Wed, 07 Jun 2017 19:07:08 GMT felipedl 2017-06-07T19:07:08Z Cryptic Error message when creating a Calculated Dimension https://community.qlik.com/t5/App-Development/Cryptic-Error-message-when-creating-a-Calculated-Dimension/m-p/1323602#M28625 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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:</P><P></P><P><SPAN style="font-size: 11pt;">If(Match(Left(FromBIC,4),'ABCD') and Match(Left(ToBIC,4),'ABCD'),'B',If(Match(Direction, 'O'), 'I', 'O'))</SPAN></P><P><SPAN style="font-size: 11pt;"><BR /></SPAN></P><P><SPAN style="font-size: 11pt;">However, I get the error that I'm missing right parenthesis.</SPAN></P><P><SPAN style="font-size: 11pt;">Could you help me identify the root cause of the error?</SPAN></P><P><SPAN style="font-size: 11pt;">Assume that the "FromBIC", "ToBIC" and "Direction" are fields that are present in the source file.<BR /></SPAN></P></BODY></HTML> Wed, 07 Jun 2017 06:52:13 GMT https://community.qlik.com/t5/App-Development/Cryptic-Error-message-when-creating-a-Calculated-Dimension/m-p/1323602#M28625 2017-06-07T06:52:13Z Re: Cryptic Error message when creating a Calculated Dimension https://community.qlik.com/t5/App-Development/Cryptic-Error-message-when-creating-a-Calculated-Dimension/m-p/1323603#M28626 <HTML><HEAD></HEAD><BODY><P>Hi Rishabh,</P><P></P><P>I created the attahed QVF file with some dummy data and your expression works fine for me.</P><P>Maybe your missing the right parenthesis on the one you inputed on your graph.</P><P>Can you share your QVF file to see if somethings up?</P><P></P><P>Regards,</P><P></P><P>Felipe.</P></BODY></HTML> Wed, 07 Jun 2017 19:07:08 GMT https://community.qlik.com/t5/App-Development/Cryptic-Error-message-when-creating-a-Calculated-Dimension/m-p/1323603#M28626 felipedl 2017-06-07T19:07:08Z