About filtering data in the Table View

The Table View in the Analysis App window includes a powerful filtering capability that allows you to precisely define the data that is displayed. Any filter applied in the Table View also applies to any visualizations associated with the table data. As you create, modify, toggle on or off, or delete filters, the Table View and any associated visualizations dynamically update to show the results.

Filters can be as simple or as complex as you need:

Table 1 summarizes the different types of filters.

Table 1. Types of filters available in the Table View

Filter type

Options

Example

Applies to

Details

Single filter

Condition

Customer number contains ‘99’

Single column

To create a conditional filter you select an operator such as Contains or Greater than, and enter a character, numeric, or date value.

Specific value or values

Customer number = ‘925007’

To create a specific-value filter you select one or more values from a list of available values.

The list contains the first 100 sorted values in the column you specified. The number of times each value appears in the column is displayed in parentheses beside the value.

You can enter a search term to restrict the values that appear in the list, or to find values beyond the first 100. The search is progressive, and finds the search term anywhere in the values. Character searches are not case-sensitive.

Combined filter

AND operator

Customer number contains ‘99’

AND

Customer number begins with‘8’

Single column

To create a combined filter you apply an additional filter to a column with an existing filter.

By default, the combined filter uses the OR operator, which means that any value in the column that satisfies at least one of the filters is displayed. If you want displayed values to satisfy both filters, you can switch to the AND operator.

You can continue to add filters for the same column to define the data displayed in the column more precisely. If you mix AND and OR operators, the sequence of the filters matters. Adjacent filters joined by AND are evaluated first, as if enclosed in parentheses.

OR operator

Customer number contains ‘99’

OR

Customer number begins with‘8’

Multi-column filter

AND operator

Customer number contains ‘99’

AND

Transaction amount < 0

Two or more columns

To create a multi-column filter you apply filters to more than one column.

The filters are joined using the AND operator (not shown in the user interface), which means that a record in the Table View must satisfy the filters on all columns to be displayed. There is no option to use the OR operator.

You can continue to add filters for different columns to define the data displayed in the Table View more precisely. Multi-column filters are cumulative. That is, each additional filter is based on the existing filtered data rather than on the entire data set.

The sequence of the filters does not matter because they are all joined by the AND operator, which means all filters have equal precedence.

AND operator and OR operator

( Customer number contains ‘99’

OR

Customer number begins with‘8’ )

AND

Transaction amount < 0

If required, a multi-column filter can include a combined filter on one or more of the columns. In this situation, all combined filters associated with individual columns are evaluated first, before filters that involve multiple columns.

Related concepts
About the Table View
Related tasks
Filtering data in the Table View


(C) 2015 ACL Services Ltd. All Rights Reserved.