topic Re: resident load where not like in QlikView

resident load where not like

Anonymous — Fri, 22 Nov 2013 13:57:28 GMT

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!

alexandros17 — Fri, 22 Nov 2013 13:58:55 GMT

try

where not field1 like "test"

Fri, 22 Nov 2013 14:26:23 GMT

Try Below:

Where NOT WildMatch(FieldName,'Test*')

Fri, 22 Nov 2013 14:28:24 GMT

Hi Robert,

You can also try "Not WildMatch" function

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

Result: 1 as M = Januari

Result: 2 as M = fex