topic Re: Operator &quot;LIKE&quot; in QlikView? in QlikView https://community.qlik.com/t5/QlikView/Operator-quot-LIKE-quot-in-QlikView/m-p/427647#M159359 <HTML><HEAD></HEAD><BODY><P>thanks very much !!! Regards!!!</P><P></P><P>done and work it!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 05 Apr 2013 18:01:04 GMT magdagarcia 2013-04-05T18:01:04Z Operator "LIKE" in QlikView? https://community.qlik.com/t5/QlikView/Operator-quot-LIKE-quot-in-QlikView/m-p/427645#M159357 <HTML><HEAD></HEAD><BODY><P>Hi everyone;</P><P>can you help me please?</P><P></P><P>In SQL server exist the Operator "LIKE" </P><P></P><P><SPAN class="st">The <EM>LIKE</EM> operator is used in a WHERE clause to&nbsp; search for a specified pattern in&nbsp; a column.</SPAN></P><P><SPAN class="st"></SPAN></P><P><SPAN class="st">Can you tell me how is call this Operator "LIKE" en Qlik View?</SPAN></P><P><SPAN class="st"></SPAN></P><P><SPAN class="st">Becasue in Qlikview is not called "LIKE" is the other way and have different name.</SPAN></P><P><SPAN class="st"></SPAN></P><P><SPAN class="st">Regards!!</SPAN></P></BODY></HTML> Fri, 05 Apr 2013 17:42:29 GMT https://community.qlik.com/t5/QlikView/Operator-quot-LIKE-quot-in-QlikView/m-p/427645#M159357 magdagarcia 2013-04-05T17:42:29Z Re: Operator "LIKE" in QlikView? https://community.qlik.com/t5/QlikView/Operator-quot-LIKE-quot-in-QlikView/m-p/427646#M159358 <HTML><HEAD></HEAD><BODY><P>There are several functions that can be used. Wildmatch and Substringcount are the two most often used.</P><P></P><P>Load Product, Sales</P><P>from ...somewhere...</P><P>where wildmatch(Product, '*phone', 'battery*','radio');</P><P></P><P>See the help file for more details.</P></BODY></HTML> Fri, 05 Apr 2013 17:45:29 GMT https://community.qlik.com/t5/QlikView/Operator-quot-LIKE-quot-in-QlikView/m-p/427646#M159358 Gysbert_Wassenaar 2013-04-05T17:45:29Z Re: Operator "LIKE" in QlikView? https://community.qlik.com/t5/QlikView/Operator-quot-LIKE-quot-in-QlikView/m-p/427647#M159359 <HTML><HEAD></HEAD><BODY><P>thanks very much !!! Regards!!!</P><P></P><P>done and work it!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 05 Apr 2013 18:01:04 GMT https://community.qlik.com/t5/QlikView/Operator-quot-LIKE-quot-in-QlikView/m-p/427647#M159359 magdagarcia 2013-04-05T18:01:04Z