topic expression error in QlikView https://community.qlik.com/t5/QlikView/expression-error/m-p/449487#M1152508 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can anyone advise what may be wrong with this expression?</P><P></P><P></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[[Risk Category]</SPAN><SPAN style="font-size: 8pt;">}) = Copers,'#FFF042' <BR /><BR />=if(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[[Risk Category]</SPAN><SPAN style="font-size: 8pt;">}) = Struggler,'#FF0000',<BR /><BR /></SPAN></P><P><SPAN style="font-size: 8pt;">Risk Category is a field within the data.</SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">Cheers</SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">Chris</SPAN></P></BODY></HTML> Fri, 12 Apr 2013 12:59:22 GMT 2013-04-12T12:59:22Z expression error https://community.qlik.com/t5/QlikView/expression-error/m-p/449487#M1152508 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can anyone advise what may be wrong with this expression?</P><P></P><P></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[[Risk Category]</SPAN><SPAN style="font-size: 8pt;">}) = Copers,'#FFF042' <BR /><BR />=if(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[[Risk Category]</SPAN><SPAN style="font-size: 8pt;">}) = Struggler,'#FF0000',<BR /><BR /></SPAN></P><P><SPAN style="font-size: 8pt;">Risk Category is a field within the data.</SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">Cheers</SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">Chris</SPAN></P></BODY></HTML> Fri, 12 Apr 2013 12:59:22 GMT https://community.qlik.com/t5/QlikView/expression-error/m-p/449487#M1152508 2013-04-12T12:59:22Z Re: expression error https://community.qlik.com/t5/QlikView/expression-error/m-p/449488#M1152509 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try these: </P><P></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;">=</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #0000ff;">if</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;">(</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #800000;">[Risk Category]</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;"> = Copers,'#FFF042' )<BR /><BR />=if(</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #800000;">[Risk Category]</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;"> = Struggler,'#FF0000')</SPAN></P><P></P><P><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;">If you need them nested into one, try this:</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;">=</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #0000ff;">if</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;">(</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #800000;">[Risk Category]</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;"> = Copers,'#FFF042' ), if(</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; font-family: Arial; color: #800000;">[Risk Category]</SPAN><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;"> = Struggler,'#FF0000'))</SPAN></P><P><SPAN style="background-color: #ffffff; font-size: 8pt; color: #737373; font-family: Arial;"><BR /></SPAN></P><P></P><P>Matt</P></BODY></HTML> Fri, 12 Apr 2013 19:40:34 GMT https://community.qlik.com/t5/QlikView/expression-error/m-p/449488#M1152509 2013-04-12T19:40:34Z Re: expression error https://community.qlik.com/t5/QlikView/expression-error/m-p/449489#M1152510 <HTML><HEAD></HEAD><BODY><P>Hi Matt,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Try this.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 8pt; color: #0000ff; font-family: Arial; background-color: #ffffff;">if</SPAN><SPAN style="font-size: 8pt; color: #737373; font-family: Arial; background-color: #ffffff;">(</SPAN><SPAN style="font-size: 8pt; color: #800000; font-family: Arial; background-color: #ffffff;">[Risk Category]</SPAN><SPAN style="font-size: 8pt; color: #737373; font-family: Arial; background-color: #ffffff;"> = 'Copers','#FFF042', if(</SPAN><SPAN style="font-size: 8pt; color: #800000; font-family: Arial; background-color: #ffffff;">[Risk Category]</SPAN><SPAN style="font-size: 8pt; color: #737373; font-family: Arial; background-color: #ffffff;"> = 'Struggler','#FF0000')) </SPAN></P><P></P><P><SPAN style="font-size: 8pt; color: #737373; font-family: Arial; background-color: #ffffff;">Regards,</SPAN></P><P><SPAN style="font-size: 8pt; color: #737373; font-family: Arial; background-color: #ffffff;">Kaushik Solanki</SPAN></P></BODY></HTML> Sat, 13 Apr 2013 07:09:54 GMT https://community.qlik.com/t5/QlikView/expression-error/m-p/449489#M1152510 kaushiknsolanki 2013-04-13T07:09:54Z