Stat-Xplore Documentation

Filters and Wafers

This section will cover:

  • Introduction
    • Example: Filters
    • Example: Wafers
  • Applying a Filter
    • Removing a Filter
  • Applying a Wafer
    • Removing a Wafer
  • Knowledge Check


Introduction

The learning objectives for this page are:

  • How to apply a specific chosen variable across your whole table

In Stat-Xplore, filters and wafers both can be used to:

  • Add an extra dimension to a table by hanging a two-dimensional table into a three-dimensional cube

Filers and wafers are applied to affect all the variables within your table. As such, when you apply either a filter or a wafer on a table, only records that match will be included in the results.

Please have a look at the practical examples below as they explain the differences between filters and wafers.


Practical Example: Filters

For example, the following table has no filters applied. You can see that under the subtitle ‘Filters’ where it is the in the ‘Default Summation’ mode.

Download format list

However, with the addition of a filter, the values in the table will now only count claimants who are ‘In Employment’. You can now see below that under the subtitle ‘Filters’ it has changed to add ‘Employment Indicator’ to reflect the filter being applied.

Download format list

Additionally, while it is also possible to add multiple filters to a table, only records matching all the filters will be included in the table



Practical Example: Wafers

The difference between filter and wafer is that the latter allows you more control. With wafers, you can select from a drop-down menu which values within the field you want to apply.

For example, by adding the field ‘Region’ to the wafer, we can see how many and what specific regions is included in the drop-down menu.

Download format list

Download format list



Applying A Filter

Now that we understand what a filter is, we need to learn how to use a filter in Table View of Stat-Xplore. To do so, once you have opened your bespoke table,

  1. From the field list on the left, select your desired field item and click the ‘Filter’ button.

    2. Download format list

  2. Stat-Xplore will then add the selected filter which can be seen above the table.

    3. Download format list

  3. Click the ‘Retrieve Data’ button to see the difference.
  4. If you would like to apply more than one filter, repeat the steps above. However, please not that you can only add one field item from any given field.

Removing A Filter

To revert the filter applied, simple click the ‘X’ button next to the filter name located above the table as seen below.

Download format list



Applying A Wafer

The steps of how to apply a wafer is very similar to how to apply a filter as taught above.

  1. From the field list on the left, select your desired field item and click the ‘Wafer’ button.
  2. Stat-Xplore will then add the selected filter which can be seen above the table.
  3. Click the ‘Retrieve Data’ button to see the difference.
  4. If you would like to switch between the different values within the field you selected, click within the drop-down menu.

Removing A Wafer

Similar to how you would remove a filter, to revert the wafer applied, simple click the ‘X’ button next to the wafer name located above the table as seen below.



Further Questions

If you still have any questions that are not answered in the guide, please feel free to email Stat.Xplore@dwp.gov.uk



Check your Knowledge!

Navigate to the dataset ‘Jobseekers Allowance’ and the data cube ‘Jobseekers Allowance’ and open the table ‘JSA 1 - Gender’. Under the hierarchy of ‘Ethnicity (detailed and summary)’, select the field ‘Asian or British Asian’. How many Asian or British Asians females had jobseekers' allowance in August 2023?

Show/hide Solution Answer Show Answer

Attachments:

SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-With-Filter.png (image/png)
SW2-Filters-Add-1.png (image/png)
SW2-Filters-Add-2.png (image/png)
SW2-Filters-Remove.png (image/png)
SW2-Filters-Remove.png (image/png)
SW2-Filters-Add-1.png (image/png)
SW2-Filters-Add-2.png (image/png)
SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-With-Filter.png (image/png)
SW2-Default-Summation-Filter.png (image/png)
SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-With-Filter.png (image/png)
SW2-Default-Summation-Filter.png (image/png)
SW2-Filters-Add-1.png (image/png)
SW2-Filters-Add-2.png (image/png)
SW2-Filters-Remove.png (image/png)
SW2-Filters-Add-1.png (image/png)
SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-With-Filter.png (image/png)
SW2-Default-Summation-Filter.png (image/png)
SW2-Filters-Add-2.png (image/png)
SW2-Filters-Remove.png (image/png)
SW2-Filters-EG-No-Filter.png (image/png)
SW2-Filters-EG-With-Filter.png (image/png)
SW2-Default-Summation-Filter.png (image/png)
SW2-Filters-Add-2.png (image/png)
SW2-Filters-Remove.png (image/png)