Stat-Xplore : Filters

Filters are an extra dimension that you can add to a table. When you apply filters to a table then only records that match the filters will be included in the results.

For example:

The following table shows Country by Gender with no filters applied:

Country by gender with 
					no filters

The following version of the table has one filter added. With the addition of this filter, the values in the table will now only count claimants who are In Employment:

In Employment filter added

It is also possible to add multiple filters to a table, and only records matching all of the filters will be included in the table. However, you can only add one field item from any given field (for example you cannot add Gender - Male and Gender - Female at the same time).

Filters and the Default Summation

When you start to create a table, Stat-Xplore automatically adds the default summation to the table filters:

Default summation highlighted

If you add a summation option to any dimension then the default summation will disappear and no longer be used.

Add a Filter to the Table

To apply a filter:

  1. Select a single field item from the tree and click Add to Filter.
    Item selected
  2. Stat-Xplore adds the filter to the list above the table.
    Filter highlighted
  3. You can now add additional field items to the filter if necessary.

    You can only add one field item from any given field.

Remove a Filter

To remove a filter, click X next to the filter name:

Remove filter button highlighted