Wave Analytics SAQL Reference
jNewer Version Available
Logical Operators
Use logical operators to perform AND, OR, and NOT operations.
Logical operators can return true, false, or null.
| Operator | Name | Description |
|---|---|---|
| && (and) | Logical AND | See table. |
| || (or) | Logical OR | See table. |
| ! (not) | Logical NOT | See table. |
The following tables show how nulls are handled in logical operations.
| x | y | x && y | x || y |
|---|---|---|---|
| True | True | True | True |
| True | False | False | True |
| True | Null | Null | True |
| False | True | False | True |
| False | False | False | False |
| False | Null | False | Null |
| Null | True | Null | True |
| Null | False | False | Null |
| Null | Null | Null | Null |
| x | !x |
|---|---|
| True | False |
| False | True |
| Null | Null |