topic Re: resident where not like in QlikView

resident where not like

Anonymous — Fri, 28 Mar 2014 16:27:19 GMT

Hi all,

I have the problem with the following:

Load

a1,

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!

arsal_90 — Fri, 28 Mar 2014 16:37:21 GMT

put not(field2) i hope it works

rwunderlich — Fri, 28 Mar 2014 16:39:31 GMT

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

-Rob

MK_QSL — Fri, 28 Mar 2014 16:50:10 GMT

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*');

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

Anonymous — Fri, 28 Mar 2014 17:41:52 GMT

Hi Rob,

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

swuehl — Fri, 28 Mar 2014 17:46:19 GMT

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.

Anonymous — Fri, 28 Mar 2014 18:25:47 GMT

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