<< Click to Display Table of Contents >> Navigation:  Reference Manual > Windows and dialog boxes > Quick tables > Quick tables

From the Main window menu [Analysis] [Quick tables] is used to produce some tables without having to create a QTF.

The tables will normally appear as formatted spreadsheet tables (Excel). If you set "Show tables output as text" in Project global, the Tables.txt file will be shown instead.

Before you can run the tables you must have at least one row or column selected and at least one data file selected.

If you have more than one row or column selected then every combination of rows and columns will be produced.

Grid entries can only be selected as rows and will be shown as a single table (not using the columns selected here).

Rows:

When you start [Quick tables], any entries that are selected on the main window will automatically be selected as the rows.  If you do want these entries to be used as the rows you can use the "Clear all" button.

You can change the selected entries to be used as the rows at any time before running the tables.

For large projects you can use the main window to select the entries, and then use the "As main window" button.

Cols:

You do not need to select any columns if you have at least one row selected.

When you start [Quick tables], no entries are selected as the columns.

You can change the selected entries to be used as the columns at any time before running the tables.

You can remove any column entries using the "Clear all" button.

For large projects you can use the main window to select the column entries, and then use the "As main window" button.

Choose data files

When you start [Quick tables] the default data file will be selected.  This will usually be the last data file used for any analysis.

You can change the data file(s) to use with the "Choose data file(s) button.

You must have data file(s) selected before you can run the tables.

Global filter

Optionally, you can set a global filter which will be used for all the tables produced. See Logic definitions for more information.

You can use the "Global filter" button, or you can type the definition into the edit box.  A tick will appear alongside for valid filter definitions.

If you use a global filter you will probably want to describe this as a table title on all tables produced.

Formats

Optionally, you can set some format options to be used for the tables. See Formats overview for more information.

These will be in addition to any global formats set for the project set with the main menu [Analysis] [Default formats].

You can use the "Formats" button or type the formats you want in the edit box.  A tick will appear alongside for valid format definitions.

Weight

If the project has an entry named "weight" this should be automatically selected when you start [Quick tables].  You can turn off the weighting with the "Use weight" check box.

Optionally, you can set the entry (integer or float) to be used as the respondent weight for all the tables with the "Weight" button or typing the entry name. A tick will appear alongside for valid entry names.

Run Tables

Use this to produce and view all the tables requested.

If spreadsheet tables are produced, the formatting will use the default settings for the project set in Main window [Analysis] [Default spreadsheet options].

The tables will be put in a file called "Quick_nnnn Tables.xlsx" or "Quick_nnnn Tables.txt" if you have set "Show tables output as text". The nnnn will be the next unused number.

Keeping tables produced

After running and viewing, the tables will normally be deleted when this window is closed or another run is started.

If you want to preserve the tables you just viewed you can check "Do not delete the last tables output file produced".

Note also that if you still have the output file open Excel when you run more tables or close this window the tables will not be deleted.