Filtering Table Overviews

Table overviews can easily be filtered. For example, in the Data Editor you can display only the rows with documents containing more than 20 codes or whose names begin with “B”:

  1. Right-click on the heading of the column you wish to filter, and select the Filter option.
Set filter by column
  1. Set the desired filter options in the window that appears.
Filter window

In all four input fields, you can define criteria to filter. The following criteria are available:

  • Contains
  • Doesn’t contain
  • Starts with
  • Greater than or Lesser than (applies to both numbers and the alphabet)
  • Earlier than and Later than (available only in columns containing a date)

OR/AND: Here you can select the manner in which the four input fields are combined. With OR, the rows in which at least one of the criteria applies are listed. With AND, the rows in which all of the criteria apply are listed.

Case sensitive – When this option is selected, you can differentiate based on whether the text in the text column appears in upper or lowercase. In this case, if “interview” in lowercase appears in the filtered column, “Interview” beginning with an uppercase letter would not be taken into account.

After clicking OK, MAXQDA filters the table overview according to the defined criteria. At the top right MAXQDA indicates how many of the originally existing rows are currently displayed.

If you set a filter for multiple columns, they are combined with the AND function.

You can switch a filter for a table overview on or off at any time using the Filter  symbol, to toggle the view between all rows and filtered rows.

If you wish to delete all defined filters in an overview, click on the Reset all filters  symbol.

Note: Each time an overview is reopened, filters in table overviews will automatically be set to “off”. The filter settings are saved individually for each overview in the project, so if you have defined a filter and reopen the project at a later time, you can turn on the filter by simply clicking the Filter  symbol.

Was this article helpful?