topic Funciotion if with multiple values in QlikView https://community.qlik.com/t5/QlikView/Funciotion-if-with-multiple-values/m-p/245747#M1182515 <HTML><HEAD></HEAD><BODY><P> Hi Bruno, this should work: If(field A=1 or 2, 'OK, if(field A = 3 or 4 or 5 or 6, 'KO', if(field A= 7 or 8 or 9, 'MAYBE'))) as new_field. </P></BODY></HTML> Mon, 02 Jan 2012 15:30:09 GMT stabben23 2012-01-02T15:30:09Z Funciotion if with multiple values https://community.qlik.com/t5/QlikView/Funciotion-if-with-multiple-values/m-p/245746#M1182514 <HTML><HEAD></HEAD><BODY><P>Hi I nedd to create a new field to summarize information coming form another field saying:</P><P>- if (field A="1or2", then 'OK',</P><P>- if (field A= "3or4or5or6", then KO"</P><P>- if (field A= "7or8or9 then "MAYBE"</P><P></P><P></P><P>How can i put togheter?</P><P></P><P>Thanks in advance</P><P></P><P>Bruno</P></BODY></HTML> Mon, 02 Jan 2012 15:23:30 GMT https://community.qlik.com/t5/QlikView/Funciotion-if-with-multiple-values/m-p/245746#M1182514 2012-01-02T15:23:30Z Funciotion if with multiple values https://community.qlik.com/t5/QlikView/Funciotion-if-with-multiple-values/m-p/245747#M1182515 <HTML><HEAD></HEAD><BODY><P> Hi Bruno, this should work: If(field A=1 or 2, 'OK, if(field A = 3 or 4 or 5 or 6, 'KO', if(field A= 7 or 8 or 9, 'MAYBE'))) as new_field. </P></BODY></HTML> Mon, 02 Jan 2012 15:30:09 GMT https://community.qlik.com/t5/QlikView/Funciotion-if-with-multiple-values/m-p/245747#M1182515 stabben23 2012-01-02T15:30:09Z Funciotion if with multiple values https://community.qlik.com/t5/QlikView/Funciotion-if-with-multiple-values/m-p/245748#M1182516 <HTML><HEAD></HEAD><BODY><P>are u sure <SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;"><STRONG>If(field A=1 or 2</STRONG> is working?</SPAN></P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">When i got just one value for category i write it as <STRONG style="color: #636363; font-size: 12px; background-color: #ffffff; font-family: Arial;">If(field A='1')</STRONG><BR /></SPAN></P></BODY></HTML> Mon, 02 Jan 2012 15:36:09 GMT https://community.qlik.com/t5/QlikView/Funciotion-if-with-multiple-values/m-p/245748#M1182516 2012-01-02T15:36:09Z Funciotion if with multiple values https://community.qlik.com/t5/QlikView/Funciotion-if-with-multiple-values/m-p/245749#M1182517 <HTML><HEAD></HEAD><BODY><P> Hi Bruno, then put all numbers between 'x'. Like if(field A='1' or '2', 'OK'............</P></BODY></HTML> Mon, 02 Jan 2012 15:40:05 GMT https://community.qlik.com/t5/QlikView/Funciotion-if-with-multiple-values/m-p/245749#M1182517 stabben23 2012-01-02T15:40:05Z