Discussion Board for collaboration on QlikView Scripting.
I have the problem with the following:
where field 1 like 'de*' and not field2 like 'e*'
The problem is that "not field2 like ..." doesn't work.
Thank you for helping!
Go to Solution.
Try like below
where field1 like 'de*' and not WildMatch(field2, 'e*');
Load * Resident TableName
Where Customer Like 'A*' and
Not WildMatch(Country, 'P*');
put not(field2) i hope it works
Could you be more specific about "not working"? Do you get a script error or don't get the filtering you expect?
the problem is that I don't get the filtering I expect.
without detailing what you expect to see (for example giving input data and your expected output table), it's almost impossible to help you.
THX:, I had to put [field test] with