The Data Editor

The MAXQDA Stats Data Editor displays the cases in the rows and the variables in the columns. Each case is therefore in a separate line. The following figure shows the Data Editor for a MAXQDA project, which essentially correponds to the Data Editor for the MAXQDA document variables. The first row provides information on the document “RESP002” which contains 6 coded segments and 0 memos. It refers to a survey respondent that is widowed, has a high job security level and is between 70 and 79 years old.

The MAXQDA Stats Data Editor

The first four columns in the example figure contain the MAXQDA system variables “Document group”, “Document name”, “Number of coded segments” and “Number of memos”. They are immutable in MAXQDA Stats and column headings are therefore displayed as in MAXQDA in black. The modifiable user variables are displayed in blue.

Individual columns can be hidden by right-clicking on the column header and choosing Hide column from the context menu. Using the Select columns function, also in the context menu, individual or all columns can be hidden or displayed, just like in MAXQDA.

Hint: The order of the columns from left to right cannot be changed, as this order always corresponds to the order of the variables in the Variable List from top to bottom.

System-defined missing values

MAXQDA Stats considers any blank fields in the Data Editor as system-defined missing. Unlike in the MAXQDA Data Editor, integer or floating point-type variable fields can also be empty.

Show value labels

The toolbar is located above the Data Editor on the left side.

Toolbar on the left side of the Data Editor

Using the icon Show value labels  the entered value of the value label will be displayed. This value can be individually defined for each variable in the Variable List. If no label is defined for a value, the value will still be displayed.

Sort, search and filter cases

Clicking on a column header in the Data Editor sorts the data in this column; clicking a second time sorts the same column in the reverse order.

Hint: On the left side of the Data Editor a sequential numbering of the rows is displayed. The numbering is fixed in order to provide orientation in the dataset; it will not be sorted. For external files, it is always advisable to provide a variable with a unique case ID.

The Data Editor in MAXQDA Stats can be searched and filtered, exactly as in MAXQDA. Clicking on the Search  icon in the toolbar above the Data Editor opens a search list in which a search query can be entered, the occurrence of which will be searched in all columns. To search in a single column, right-click on the column header and select Search.

The filter function can similarly be called up for a column as follows:

  1. Right-click on a column header.
  2. Select Filter.
  3. In the dialog box, define a filter criteria and click OK.
Enter filter criteria

The number of cases currently in the Data Editor can be seen in the bottom right of the status bar. Only these cases are included in the calculations.

To switch the currently set filter on and off, click on the Filter  icon in the toolbar above the Data Editor. To delete all filters, click on the  icon.

Go to case

To jump to a particular case in a row, click on the  icon in the toolbar above the Data Editor. A small dialog box will appear where you can enter the target row.

Insert new cases

When MAXQDA Stats is called up for a MAXQDA project, it is not possible to insert new cases, as this would be synonomous with the insertion of further documents in the MAXQDA project itself. The situation is different when you create or open a new external file. In this instance, it is of course possible to add additional cases to the data set, which can be done as follows:

  1. Scroll to the bottom of the data set
  2. A blank row is located in the last row of the Data Editor. As soon as any content is entered in any column, this row will be assigned a consecutive number and another blank row for the next record will appear underneath the previous row.

Delete cases

When you work with an external file in MAXQDA Stats, you can delete individual or multiple cases as follows:

  1. In the Data Editor, highlight a single case with the mouse, or highlight multiple cases by pressing the Ctrl/cmd key.
  2. Right-click the highlighted area and select Delete selected cases. Alternatively, you can click on the Delete icon  in the toolbar above the Data Editor.

Export Data Editor

At the top right of the Data Editor a typical MAXQDA toolbar is located, which contains the following icons for exporting data.

  Open as Excel table – When you click on this icon, the current view will be displayed as a temporary Excel file. If you wish to save this file, you must do so in Excel. Value labels that are displayed in MAXQDA Stats will also be displayed in Excel.

  Open as HTML table – When you click on this icon, the current view will be displayed as a temporary HTML file in the default browser. If you wish to save this file, you must do so in the selected browser. Value labels that are displayed in MAXQDA Stats will also be displayed in the HTML file.

  Export – When this function is selected, a file dialog will appear in which you can select from Excel or HTML export formats and specify a file name and location. The file will open automatically following the export process. Value labels that are displayed in MAXQDA will also be exported.

The currently displayed data can be saved as an SPSS file by selecting File > Save as from the main menu.