Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
tma55515
New Contributor II

equivalent of "not like"?

hi..

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

1 Solution

Accepted Solutions

equivalent of "not like"?

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

View solution in original post

7 Replies
Highlighted
Not applicable

equivalent of "not like"?

<>

MVP & Luminary
MVP & Luminary

equivalent of "not like"?

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.

equivalent of "not like"?

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

View solution in original post

tma55515
New Contributor II

equivalent of "not like"?

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

pk
New Contributor II

Re: equivalent of "not like"?

is it working in the bar chart ?

Partner
Partner

Re: equivalent of "not like"?

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
New Contributor III

Re: equivalent of "not like"?

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