Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Where clause

Hi,

Am having a spot of bother with a 'simple' where clause when loading from a qvd file.

Background: I have 2 fields SURNAME and FULLNAME. I want to exclude any value where there is a double bracket attached to the end of either field.

Code as follows:

Where Right(SURNAME,2)<>'))' OR Right(FULLNAME,2)<>'))';

Have also tried:

Where Right(SURNAME,2) OR Right(FULLNAME,2)<>'))';

When running the command none of the defined values for exclusion are actually excluded.

The command works fine if I run the code with only 1 field defined (without the 'OR' clause).

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Where clause


Karl wrote:I want to exclude any value where there is a double bracket attached to the end of either field.


If you want to exclude the values if either of the fields has brackets, it means (in reverse) that you want to include only those values where both fields don't have the brackets. Simply put, you need to replace your OR condition with an AND condition, and I believe it will work the way you wanted...