Using the Quick Filter Utility

Performing Standard Data Operations > Filtering Data > Using the Quick Filter Utility

When performing analysis on a data set, it is helpful to have a way to filter data quickly using broad matching terms.  One way to do this with Strata is using the Quick Filter utility.

The Quick Filter can be found on the toolbar at the top right of your screen and shares the same "Find/Filter" criteria box as the Find utility.

The above picture shows an unfiltered data set.  However, if we wanted to filter on the data so that we only saw instances of the word "ABC", we could enter "ABC" into the Find/Filter box and click on the Quick Filter icon as shown below:

One of the nice features of the quick filter is that it will accept broader criteria than required when creating custom filtering criteria.  For example, we could use the filter criteria "ABC" or "abc" or AbC" and still get the same result (for matching based on case or whole word,see the section Using the Find Panel).

By default, the quick filter will filter any data in your data set.  However, if you want to be more specific, you may just highlight the field(s) you want to filter upon and the quick filter will limit the criteria to those selected fields.

The quick filter also offers a mechanism for entering in custom Boolean formulas, similar to what you can do with when creating a custom filter.

In this example, we've created a formula on the same data set that shows only amounts that are greater than 1000.

For large data tables, it may take a few seconds or minutes to filter the records.  If you wish to cancel the operation, you may simply click on the filter icon a second time to cancel the job.