topic Re: Equals Versus Not Equals - any efficiency difference? in QlikView https://community.qlik.com/t5/QlikView/Equals-Versus-Not-Equals-any-efficiency-difference/m-p/261846#M98655 <HTML><HEAD></HEAD><BODY><P><EM style="font-family: trebuchet ms,geneva;">Hi,</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Sorry, I am not clear with your question. But do you know that you can use the below :</EM></P><P></P><P><SPAN style="color: #000080;"><STRONG><EM style="font-family: trebuchet ms,geneva;">Match (Field,'A','B','C') OR</EM></STRONG></SPAN></P><P><SPAN style="color: #000080;"><STRONG><EM style="font-family: trebuchet ms,geneva;">Not match (Field,'F')</EM></STRONG></SPAN></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Match() - function is essentially is the same as an "IN" clause in SQL Server.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">I hope this makes sense!</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Cheers - DV</EM></P></BODY></HTML> Wed, 14 Sep 2011 15:40:04 GMT IAMDV 2011-09-14T15:40:04Z Equals Versus Not Equals - any efficiency difference? https://community.qlik.com/t5/QlikView/Equals-Versus-Not-Equals-any-efficiency-difference/m-p/261845#M98654 <HTML><HEAD></HEAD><BODY><P>When loading data from a QVD into a QVW with limitations as to what records should be pulled in, is there any difference in efficiency between using equals versus not equals?</P></BODY></HTML> Wed, 14 Sep 2011 15:01:47 GMT https://community.qlik.com/t5/QlikView/Equals-Versus-Not-Equals-any-efficiency-difference/m-p/261845#M98654 2011-09-14T15:01:47Z Re: Equals Versus Not Equals - any efficiency difference? https://community.qlik.com/t5/QlikView/Equals-Versus-Not-Equals-any-efficiency-difference/m-p/261846#M98655 <HTML><HEAD></HEAD><BODY><P><EM style="font-family: trebuchet ms,geneva;">Hi,</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Sorry, I am not clear with your question. But do you know that you can use the below :</EM></P><P></P><P><SPAN style="color: #000080;"><STRONG><EM style="font-family: trebuchet ms,geneva;">Match (Field,'A','B','C') OR</EM></STRONG></SPAN></P><P><SPAN style="color: #000080;"><STRONG><EM style="font-family: trebuchet ms,geneva;">Not match (Field,'F')</EM></STRONG></SPAN></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Match() - function is essentially is the same as an "IN" clause in SQL Server.</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">I hope this makes sense!</EM></P><P></P><P><EM style="font-family: trebuchet ms,geneva;">Cheers - DV</EM></P></BODY></HTML> Wed, 14 Sep 2011 15:40:04 GMT https://community.qlik.com/t5/QlikView/Equals-Versus-Not-Equals-any-efficiency-difference/m-p/261846#M98655 IAMDV 2011-09-14T15:40:04Z