Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

robert2012
New Contributor III

resident where not like

Hi all,

I have the problem with the following:

Load

a1,

b1

resident table1

where field 1 like 'de*' and not field2 like 'e*'

The problem is that "not field2 like ..." doesn't work.

Any ideas?

Thank you for helping!

1 Solution

Accepted Solutions
MVP
MVP

Re: resident where not like

Try like below

======================================

Load

a1,

b1,

.....

resident table1

where field1 like 'de*' and not WildMatch(field2,  'e*');

============================================

Something like

Load  * Resident TableName

Where Customer Like 'A*' and

Not WildMatch(Country, 'P*');

============================================

6 Replies
Highlighted
arsal_90
Contributor III

Re: resident where not like

put not(field2) i hope it works

MVP & Luminary
MVP & Luminary

Re: resident where not like

Could you be more specific about "not working"? Do you get a script error or don't get the filtering you expect?

-Rob

MVP
MVP

Re: resident where not like

Try like below

======================================

Load

a1,

b1,

.....

resident table1

where field1 like 'de*' and not WildMatch(field2,  'e*');

============================================

Something like

Load  * Resident TableName

Where Customer Like 'A*' and

Not WildMatch(Country, 'P*');

============================================

robert2012
New Contributor III

Re: resident where not like

Hi Rob,

the problem is that I don't get the filtering I expect.

MVP
MVP

Re: resident where not like

Robert,

without detailing what you expect to see (for example giving input data and your expected output table), it's almost impossible to help you.

robert2012
New Contributor III

Re: resident where not like

THX:, I had to put [field test] with []