Applying filters

This feature is available in NVivo Pro and Plus editions. Learn more

 


When you work with data in rows and columns—for example, datasets, matrices or transcripts—you can use filters to see a subset of the information.

What do you want to do?


 


Understand filtering

Filters can make information (such as datasets, transcripts and matrices) easier to work with. You can display only the rows that meet the criteria you specify and hide everything else. Working with a smaller set of data can make it easier to code, annotate or link. Filtering does not change your data in any way and you can easily clear a filter to see all of the data again.

You can only apply filters to columns or rows that display a filter icon . The filter icon changes to red when the data has been filtered.

The Status bar also shows whether the information in the Detail View is filtered or unfiltered.

NOTE

Top of Page

Create a filter

  1. Select a column that displays the filter icon.

  2. On the Layout tab, in the Sort & Filter group, click Filter and then click Filter Column.

The dialog box opens.

Shortcut You can also click the filter icon to create a filter.

  1. Use the following steps to define the filter:

a Select Show or Hide—do you want to show or hide the rows that match the criteria?

b Select the type of filter—do you want to filter anything  that 'equals' or 'contains' the specified text or is 'greater than' a specified value?

c Enter or select the criteria that you want to filter on.

  1. Click OK to apply the filter.

Top of Page

Filter text

You can filter rows based on the text they contain—for example, show only rows that contain the text ipsum:

There are various other types of text filters that you can create, for example:

  • Hide the rows that contain the text ipsum.

  • Show rows that exactly match (equal) the text string lorem ipsum.

In transcripts and picture logs, you can filter on more than one item—choose contains any of and enter each item separated by a comma. For example, you could create a filter to show any rows where Speaker 'contains any of' Betty, Paul which would display transcript rows where either Betty or Paul were speaking.

Top of Page

Filter numbers

You can filter rows based on the numbers they contain—for example:

  • Show the rows with values greater than 42.

  • Hide the rows with values less than 300.

  • Show the rows with values greater than or equal to 200 and less than or equal to 500.

Top of Page

Filter dates and times

You can filter rows based on the dates and times they contain—for example:

  • Show the rows with date less than 04/03/2009.

  • Hide the rows with date less than 04/03/2009.

  • Show the rows with date and time greater than 04/03/2009 12:00 AM.

Top of Page

Filter for blanks and non-blanks

You can filter rows by showing or hiding rows that contain empty cells. For example, you could filter a transcript to see only the timespans that have recorded content.

Top of Page

Apply multiple filters

You can apply filters on more than one column. As each additional column is filtered, the number of rows is further reduced.

NOTE Multiple filters cannot be applied to matrices.

Top of Page

Clear a filter

  1. Select the column that contains the filter you want to clear.

  2. On the Layout tab, in the Sort & Filter group, click Filter and then click Clear Filter on Column.

The selected filter is cleared.

Shortcut Click filter icon , then select the Clear Filter button on the dialog box.

NOTE To clear all filters, click Filter in the Sort & Filter group on the Layout tab, and then click Clear All Column Filters.

Top of Page

Change a filter

  1. Select the column that contains the filter you want to change.

  2. On the Layout tab, in the Sort & Filter group, click Filter and then click Filter Column.

The dialog box opens.

  1. Make the changes to the filter.

  2. Click OK.

Shortcut Click the filter icon and make the changes to the filter.

Top of Page