Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
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...