topic Where with multiple values in QlikView https://community.qlik.com/t5/QlikView/Where-with-multiple-values/m-p/1362118#M831725 <HTML><HEAD></HEAD><BODY><P>Hi<SPAN style="font-size: 10pt;">everyvone, i'm loading a qvd file and i want to set a where clause with multiple values.</SPAN></P><P><SPAN style="font-size: 10pt;">What is wrong in my statement below?</SPAN></P><P><SPAN style="font-size: 10pt;">Thank you for your time.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><IMG alt="where condition.PNG" class="jive-image image-1" height="81" src="/legacyfs/online/166709_where condition.PNG" style="height: 80.6161px; width: 746px;" width="746" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT qlikviewaf 2020-11-25T16:16:04Z Where with multiple values https://community.qlik.com/t5/QlikView/Where-with-multiple-values/m-p/1362118#M831725 <HTML><HEAD></HEAD><BODY><P>Hi<SPAN style="font-size: 10pt;">everyvone, i'm loading a qvd file and i want to set a where clause with multiple values.</SPAN></P><P><SPAN style="font-size: 10pt;">What is wrong in my statement below?</SPAN></P><P><SPAN style="font-size: 10pt;">Thank you for your time.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><IMG alt="where condition.PNG" class="jive-image image-1" height="81" src="/legacyfs/online/166709_where condition.PNG" style="height: 80.6161px; width: 746px;" width="746" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Where-with-multiple-values/m-p/1362118#M831725 qlikviewaf 2020-11-25T16:16:04Z Re: Where with multiple values https://community.qlik.com/t5/QlikView/Where-with-multiple-values/m-p/1362119#M831726 <HTML><HEAD></HEAD><BODY><P>May be try like this</P><P></P><P><STRONG>Where not WildMatch(SDDCTO, 'CR', 'SR', 'UK', ......)</STRONG></P></BODY></HTML> Tue, 13 Jun 2017 13:23:47 GMT https://community.qlik.com/t5/QlikView/Where-with-multiple-values/m-p/1362119#M831726 sunny_talwar 2017-06-13T13:23:47Z Re: Where with multiple values https://community.qlik.com/t5/QlikView/Where-with-multiple-values/m-p/1362120#M831727 <HTML><HEAD></HEAD><BODY><P>You cannot add multiple expressions with a logical operator,</P><P>easiest would be to use Sunny's suggestion.</P><P>Simplified you may also write</P><P>WHERE SDDCTO &lt;&gt; 'CR' AND SDDCTO &lt;&gt; 'SR' AND SDDCTO &lt;&gt; 'UK' etc. (analogue to the second row of your where-clause).</P></BODY></HTML> Tue, 13 Jun 2017 15:10:57 GMT https://community.qlik.com/t5/QlikView/Where-with-multiple-values/m-p/1362120#M831727 prieper 2017-06-13T15:10:57Z