topic Re: Like function in QlikView https://community.qlik.com/t5/QlikView/Like-function/m-p/438748#M1155229 <HTML><HEAD></HEAD><BODY><P>try</P><P></P><P>if( <STRONG>not </STRONG>FIELD <STRONG> </STRONG>like '*SEARCHSTRING*' and...</P><P></P><P>Nachricht geändert durch swuehl</P></BODY></HTML> Wed, 13 Mar 2013 18:19:37 GMT swuehl 2013-03-13T18:19:37Z Like function https://community.qlik.com/t5/QlikView/Like-function/m-p/438746#M1155225 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Does somebody knows what's wrong with my experssion?</P><P></P><P>Count (if(el4naam like '*HOOL*'= 0 and (Groep1='M10' or Groep1='M20'),MISTotaal))</P><P></P><P></P><P>Example</P><P>-------------</P><P></P><P>el4naam</P><P>***********</P><P>VAN HOOL NV</P><P>NMBS<BR />ELECTRABEL</P><P>NETHERLAND VAN HOOL</P><P></P><P>=&gt; I want to filter all values except VAN HOOL NV and NETHERLAND VAN HOOL</P><P></P><P>Grtz<BR />Tim</P></BODY></HTML> Wed, 13 Mar 2013 18:11:54 GMT https://community.qlik.com/t5/QlikView/Like-function/m-p/438746#M1155225 2013-03-13T18:11:54Z Re: Like function https://community.qlik.com/t5/QlikView/Like-function/m-p/438747#M1155227 <HTML><HEAD></HEAD><BODY><P>There is nothing wrong with the Groep1 part..</P></BODY></HTML> Wed, 13 Mar 2013 18:12:41 GMT https://community.qlik.com/t5/QlikView/Like-function/m-p/438747#M1155227 2013-03-13T18:12:41Z Re: Like function https://community.qlik.com/t5/QlikView/Like-function/m-p/438748#M1155229 <HTML><HEAD></HEAD><BODY><P>try</P><P></P><P>if( <STRONG>not </STRONG>FIELD <STRONG> </STRONG>like '*SEARCHSTRING*' and...</P><P></P><P>Nachricht geändert durch swuehl</P></BODY></HTML> Wed, 13 Mar 2013 18:19:37 GMT https://community.qlik.com/t5/QlikView/Like-function/m-p/438748#M1155229 swuehl 2013-03-13T18:19:37Z Re: Like function https://community.qlik.com/t5/QlikView/Like-function/m-p/438749#M1155231 <HTML><HEAD></HEAD><BODY><P>Perfect! </P><P></P><P>Thanks Sweuhl!!</P></BODY></HTML> Wed, 13 Mar 2013 18:24:30 GMT https://community.qlik.com/t5/QlikView/Like-function/m-p/438749#M1155231 2013-03-13T18:24:30Z