topic IF function syntax in QlikView https://community.qlik.com/t5/QlikView/IF-function-syntax/m-p/409762#M697397 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The field 'class' has AAA and EAA, i would want to classify the records into ACCIDENT or ENGINEERING.</P><P></P><P>The syntax below didnot work. Please help</P><P></P><P>load *,</P><P></P><P>IF(LEFT(class,1)='A','ACCIDENT'),</P><P>IF(LEFT(class,1)='E','ENGINEERING') as Class_Name,</P></BODY></HTML> Tue, 05 Mar 2013 15:23:08 GMT Anonymous 2013-03-05T15:23:08Z IF function syntax https://community.qlik.com/t5/QlikView/IF-function-syntax/m-p/409762#M697397 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The field 'class' has AAA and EAA, i would want to classify the records into ACCIDENT or ENGINEERING.</P><P></P><P>The syntax below didnot work. Please help</P><P></P><P>load *,</P><P></P><P>IF(LEFT(class,1)='A','ACCIDENT'),</P><P>IF(LEFT(class,1)='E','ENGINEERING') as Class_Name,</P></BODY></HTML> Tue, 05 Mar 2013 15:23:08 GMT https://community.qlik.com/t5/QlikView/IF-function-syntax/m-p/409762#M697397 Anonymous 2013-03-05T15:23:08Z Re: IF function syntax https://community.qlik.com/t5/QlikView/IF-function-syntax/m-p/409763#M697398 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Try moving a parenthesis to the end:</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">IF(LEFT(class,1)='A','ACCIDENT', IF(LEFT(class,1)='E','ENGINEERING')) as Class_Name,</P></BODY></HTML> Tue, 05 Mar 2013 15:27:33 GMT https://community.qlik.com/t5/QlikView/IF-function-syntax/m-p/409763#M697398 Gysbert_Wassenaar 2013-03-05T15:27:33Z