On this page
Kater SQL Functions Conditions
Conditions
A condition is TRUE or FALSE for each row.
Write it in WHERE to keep the rows where it is TRUE, in a filter that a reader turns on, or in a dimension that flags rows. The Filters menu writes them. A value can come from a parameter that a reader supplies, such as :region. See Filters and parameters.
| Function | What it does |
|---|---|
KATER__IS_EQUAL_TO | True where the field equals the value. |
KATER__IS_NOT_EQUAL_TO | True where the field does not equal the value. |
KATER__IS_GREATER_THAN | True where the field is greater than the value. |
KATER__IS_AT_LEAST | True where the field is greater than or equal to the value. |
KATER__IS_LESS_THAN | True where the field is less than the value. |
KATER__IS_AT_MOST | True where the field is less than or equal to the value. |
KATER__IS_BETWEEN | True where the field is between the low and the high end, both ends included. |
KATER__IS_ONE_OF | True where the field equals one of the values. |
KATER__IS_NOT_ONE_OF | True where the field equals none of the values. |
KATER__TEXT_CONTAINS | True where the text contains the value, in any letter case. |
KATER__TEXT_DOES_NOT_CONTAIN | True where the text does not contain the value, in any letter case. |
KATER__IS_NULL | True where the field is empty. |
KATER__IS_NOT_NULL | True where the field has a value. |