Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

robert2012
New Contributor III

resident load where not like

Hi

I always made my resident loads with where Field1 like "Test".

No I want to make a resident load where Field1 NOT like "Test".

As the NOT is not right, do you know the right expression?

Thank you very much for your answers!

1 Solution

Accepted Solutions

Re: resident load where not like

try

where not field1 like "test"

3 Replies

Re: resident load where not like

try

where not field1 like "test"

Not applicable

Re: resident load where not like

Try Below:

Where NOT WildMatch(FieldName,'Test*')

Not applicable

Re: resident load where not like

Hi Robert,

You can also try "Not WildMatch" function

wildmatch( M, 'ja*','fe?','mar')

Result: 1 as M = Januari

Result: 2 as M = fex

Community Browser