Exclusion filters

Feedback
1

Hi, there is no mention in the documentation or examples showing exclusion filters (i.e. Dimension != "value" or dimension not in ("value1", "value2")). It would be great if either an express statement that exclusion filters are not supported at this time or, if they are, an example be included.

1 Like
2

Hi @derek.stobbart ,
The negation ( NOT) needs to precede the dimension. Example:

SELECT 
    resignationRate(), 
    level(Employee.Location, "Location_1") Country,
    Visier_Time AS Time 
FROM Employee_Exit 
WHERE 
    Visier_Time IN periods(date("2020-04-01"), 1, period(3, Month)) AND
    Employee.isFemale = TRUE AND
    NOT Employee.Location IN (("North America", "United States"))
3

Thanks for this Henrik.
I’m having trouble making this work for “IN” style queries with lists, but can get a result if I use it with single value “=” statements. Is there any additional guidance needed to make an exclusion list?
It would be great to update the documentation with some examples that show this.

4

Sorry - this is working correctly. It happens that I hit another issue that was causing the query to fail. The exclusions work both for the “IN” case and the “=” case.