topic if statement equal to several values in QlikView https://community.qlik.com/t5/QlikView/if-statement-equal-to-several-values/m-p/336904#M124206 <HTML><HEAD></HEAD><BODY><DIV><SPAN style="color: #000000; font-size: 12pt;"> Hi Community,&nbsp; If we have an if statement like<DIV><SPAN style="color: #0000ff; font-size: 12pt;"> </SPAN></DIV><SPAN style="color: #0000ff; font-size: 12pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 12pt;"><DIV>if<SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #800000; font-size: 12pt;">el1</SPAN><SPAN style="font-size: 12pt;">='9000',</SPAN><SPAN style="color: #800000; font-size: 12pt;">dog</SPAN><SPAN style="font-size: 12pt;">='red') how do I add another value to what dog is equal to? </SPAN></DIV></SPAN></SPAN></DIV><DIV><SPAN style="font-size: 12pt;"> </SPAN></DIV></BODY></HTML> Fri, 04 May 2012 13:59:52 GMT 2012-05-04T13:59:52Z if statement equal to several values https://community.qlik.com/t5/QlikView/if-statement-equal-to-several-values/m-p/336904#M124206 <HTML><HEAD></HEAD><BODY><DIV><SPAN style="color: #000000; font-size: 12pt;"> Hi Community,&nbsp; If we have an if statement like<DIV><SPAN style="color: #0000ff; font-size: 12pt;"> </SPAN></DIV><SPAN style="color: #0000ff; font-size: 12pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 12pt;"><DIV>if<SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #800000; font-size: 12pt;">el1</SPAN><SPAN style="font-size: 12pt;">='9000',</SPAN><SPAN style="color: #800000; font-size: 12pt;">dog</SPAN><SPAN style="font-size: 12pt;">='red') how do I add another value to what dog is equal to? </SPAN></DIV></SPAN></SPAN></DIV><DIV><SPAN style="font-size: 12pt;"> </SPAN></DIV></BODY></HTML> Fri, 04 May 2012 13:59:52 GMT https://community.qlik.com/t5/QlikView/if-statement-equal-to-several-values/m-p/336904#M124206 2012-05-04T13:59:52Z if statement equal to several values https://community.qlik.com/t5/QlikView/if-statement-equal-to-several-values/m-p/336905#M124207 <HTML><HEAD></HEAD><BODY><P>I not understood very well but try help you.</P><P></P><P>Sorry for my bad English.</P><P></P><P></P><P>To evaluate 2 or more conditions:</P><P></P><P>If(eI1='9000' and dog='red', dog='blue')</P><P></P><P>To anidate conditions:</P><P></P><P>If(eI1='9000', dog='red', If(dog='blue', eI1='5000', 0))</P><P></P><P></P><P>Regards.-</P></BODY></HTML> Fri, 04 May 2012 14:14:48 GMT https://community.qlik.com/t5/QlikView/if-statement-equal-to-several-values/m-p/336905#M124207 2012-05-04T14:14:48Z if statement equal to several values https://community.qlik.com/t5/QlikView/if-statement-equal-to-several-values/m-p/336906#M124208 <HTML><HEAD></HEAD><BODY><P> if(el1='9000' and (dog='red' or dog='blue', thensomething, elsesomething)</P><P></P><P>or </P><P></P><P> if(el1='9000' and match(dog,'red','blue'), thensomething, elsesomething)</P></BODY></HTML> Fri, 04 May 2012 14:32:41 GMT https://community.qlik.com/t5/QlikView/if-statement-equal-to-several-values/m-p/336906#M124208 danielrozental 2012-05-04T14:32:41Z