Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
New 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...