Filter Conditional Statements

A condition is a combination of a data field (dataset column), an operator and a value (conditional block).

Structure of a 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.

Filter Conditional Block

Operators

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.

Operators by Data Type

Below is a list of supported operators for each data type.

Operator	Text	Numeric	Date
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

Value

Static (Fixed) Value

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 Value

Relative values are supported for date fields

Today	Tomorrow	Yesterday	Min Date	Max Date

Add other Conditional Blocks

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.