NOT BETWEEN

The NOT BETWEEN operator computes the metric by using attribute values, metrics or macros, outside of a specified range (including/excluding endpoints). As a filtering operator, it excludes attribute values that fall within some specified range. The range is specified by two inclusive attribute value endpoints.

Syntax

SELECT … WHERE … NOT BETWEEN … AND …
SELECT metric WHERE attribute NOT BETWEEN attribute_value1 AND attribute_value2

Examples

SELECT Profit WHERE Year NOT BETWEEN 2005 AND 2008
SELECT Sales WHERE Quarter NOT BETWEEN THIS - 5 AND THIS)