Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Like function

Hi,

Does somebody knows what's wrong with my experssion?

Count (if(el4naam like '*HOOL*'= 0 and (Groep1='M10' or Groep1='M20'),MISTotaal))

Example

-------------

el4naam

***********

VAN HOOL NV

NMBS
ELECTRABEL

NETHERLAND VAN HOOL

=> I want to filter all values except VAN HOOL NV and NETHERLAND VAN HOOL

Grtz
Tim

1 Solution

Accepted Solutions
swuehl
MVP
MVP

try

if( not FIELD like '*SEARCHSTRING*' and...

Nachricht geändert durch swuehl

View solution in original post

3 Replies
Not applicable
Author

There is nothing wrong with the Groep1 part..

swuehl
MVP
MVP

try

if( not FIELD like '*SEARCHSTRING*' and...

Nachricht geändert durch swuehl

Not applicable
Author

Perfect!

Thanks Sweuhl!!