topic Expression failing when there are multiple possible values in QlikView https://community.qlik.com/t5/QlikView/Expression-failing-when-there-are-multiple-possible-values/m-p/440946#M164371 <HTML><HEAD></HEAD><BODY><P>Hi guys. So I have a chart expression that contains an if statement looking for a certain field value. In that field, however, there are several possible values, depending on the current selections. I basically want the if statement to be true if one of the possible values is a string that I define. The expression always seems to return false though if there are multiple possible values.</P><P>So if my expression is like this:</P><P>=if(FieldA='Value", 'True','False')</P><P>And if the current possible values for FieldA given the selections are {'Value','Value2','Value3'}, I want the above expression to return true.</P><P>Any ideas what I should do here? Thanks!</P></BODY></HTML> Fri, 15 Feb 2013 17:06:47 GMT 2013-02-15T17:06:47Z Expression failing when there are multiple possible values https://community.qlik.com/t5/QlikView/Expression-failing-when-there-are-multiple-possible-values/m-p/440946#M164371 <HTML><HEAD></HEAD><BODY><P>Hi guys. So I have a chart expression that contains an if statement looking for a certain field value. In that field, however, there are several possible values, depending on the current selections. I basically want the if statement to be true if one of the possible values is a string that I define. The expression always seems to return false though if there are multiple possible values.</P><P>So if my expression is like this:</P><P>=if(FieldA='Value", 'True','False')</P><P>And if the current possible values for FieldA given the selections are {'Value','Value2','Value3'}, I want the above expression to return true.</P><P>Any ideas what I should do here? Thanks!</P></BODY></HTML> Fri, 15 Feb 2013 17:06:47 GMT https://community.qlik.com/t5/QlikView/Expression-failing-when-there-are-multiple-possible-values/m-p/440946#M164371 2013-02-15T17:06:47Z