Filter Conditional Statements
Last updated
Last updated
A condition is a combination of a data field (dataset column), an operator and a value (conditional block).
A filter condition block in ViewZen Analytis comprises of five components
Conditional field - This is the field on which the condition is applied. This is always a dataset column.
Operator - Determines how the conditional field is compared against a value.
Value - The specific value against which the conditional field is evaluated. Value can be a fixed or a relative value.
Delete - The delete button can be used to delete that particular condition.
Add another additional block - This creates an additional conditional block at the same level or as a child within the conditional hierarchy.
The following operators are supported in filter conditional statements
Equal - Applicable only for all valid input fields. Verifies if there is an exact match with the selected list of values.
Not Equal - Applicable only for all valid input fields. Ignores records for which there is an exact match with the selected list of values.
Starts with - The "Starts With" operator is used to filter records where the specified text field begins with a particular sequence of characters.
Ends with - The "Ends With" operator is used to filter records where the specified text field concludes with a particular sequence of characters.
Contains - The "Contains" operator is used to filter records where a specified text field includes a particular sequence of characters anywhere within it.
Greater than - Applicable only for number and date input fields. Checks if the data is greater than the provided value.
Greater than Equal - Applicable only for number and date input fields. Checks if the data is greater than or equal to the provided value.
Less than - Applicable only for number and date input fields. Checks if the data is lesser than the provided value.
Less than Equal - Applicable only for number and date input fields. Checks if the data is lesser than or equal to the provided value.
Between - The "Between" operator is used to filter data within a specified range. It includes the lower but does not include the upper boundary values.
Not Between - The "Not Between" operator is used to exclude data within a specified range. It filters out values that fall between the given lower and upper boundaries, including the lower end point but excluding the upper end point.
Is Null - The "Is Null" operator is used to filter records where the specified field has null value (i.e., it contains a null value). Empty values are not filtered out.
Is Not Null - The "Is Not Null" operator is used to filter records where the specified field contains a value (i.e., it is not null). Empty values are not filtered out.
Below is a list of supported operators for each data type.
Equal
Yes
Yes
Yes
Not Equal
Yes
Yes
Yes
Starts with
Yes
Ends with
Yes
Contains
Yes
Greater than
Yes
Yes
Greater than Equal
Yes
Yes
Less than
Yes
Yes
Less than Equal
Yes
Yes
Between
Yes
Yes
Not Between
Yes
Yes
Is Null
Yes
Yes
Yes
Is Not Null
Yes
Yes
Yes
A Static Value is a fixed, predefined value that does not change dynamically based on user input or system conditions. It is manually entered or selected from a list of allowed values during configuration.
Relative values are supported for date fields
Today
Tomorrow
Yesterday
Min Date
Max Date
Conditions grouped under the same logical operator (AND or OR) form a single block.
Nesting in conditional blocks - Conditional statements can be nested infinitely. Additional conditions can be added to the same block using the same operator, or a sub-block can be created using the alternative logical operator.
