equivalent of "not like"?

[Anonymous]

hi..

what is the equivalent of "not like" in the qv script?

[#2]

<>

[jagan]

Hi,

Try

WildMatch() helps in dealing situations like this.  If it returns 0 then it means that there is no match, it is similar to no like SQL.

WildMatch(FieldName, value1, value2) = 0

Regards,

Jagan.

[CELAMBARASAN · Accepted solution]

Hi,

     Wild match is the only replacement for like in qlikview with some extended.

     You can use like this

     Load

          *

     From datasource

     Where not WildMatch(FieldName,'value*','value2*');

Celambarasan

[Anonymous]

thanks everybody...i used not wildmatch(field, '*abc*')

[pk]

is it working in the bar chart ?

[shar]

Hi, 

The not wildmatch is not loading the data with NULL values.

Ex: 

Col A    Linecd

Apple 1

Ball    2

Null    3

If I say "NOT WILDMATCH(COLA,'Apple')"" - the result is just 2 but ideally I should be getting 2 and 3 right? 

Thank you!

[LucasIsidoro]

I'm from Brazil and I used your solution. Thank you.