|
<< Click to Display Table of Contents >> Navigation: Reference Manual > Windows and dialog boxes > Tables setup > Tables setup |
From the Main window menu [Analysis] [Tables setup QTF] is used to create, update and run tables.
It has a menu and a toolbar that are always present.
The different types of table are described in the Tables overview.
The display has a number of different sections:
The menus can be used as described in the menu section.
The toolbar buttons are a quick way to access the same functionality as the most commonly use menu selections.
If the project has groups of entries these groups are listed on the top left of the display area.
A group can be dragged into the tables list and a table will be added for every entry in the list that can be used as the rows of a table. Only the rows will be set in these new tables but they will remain selected so that other settings can be made to all of them, for example the columns (breakdown).
You can choose to hide (or show) all the entries in selected groups from the list of entries on the left of the display.
This list on the left of the display shows all the (not hidden) entries in the project.
Entries can be dragged and dropped into the tables list. A table will be added for every entry in the list that can be used as the rows of a table. Only the rows will be set in these new tables but they will remain selected so that other settings can be made to all of them, for example the columns (breakdown).
Individual valid entries can also be dragged and dropped into the boxes at the right of display (Row, Column, Quantity) when one or more tables are selected.
If a Grid variable is dragged into the tables list it creates a grid table using the VGRIDE/VGRIDT pair. Only VGRIDE variables are listed, VGRIDT variables are not shown.
The context menu (right click) can be used to create tables from selected entries. If any grid variables are selected they will create grid tables.
This is a list of all the tables in the tables file and appears in the centre of the display.
You can select one more tables in the list and alter all their contents at the same time.
The menus and toolbar buttons usually only affect selected items in the list.
There is a context (right mouse) menu that can be used. Also the usual Windows shortcut keys can be used to cut, copy, paste and delete.
You can widen the list to see extra information about the tables.
This area on the right of the display is used to show the contents of the selected table.
When more than one table is selected this area shows the things that are common to all the selected tables. If a particular setting is not the same for all the selected tables it will be shown as:
{Varies} in the edit boxes
A black square in the check boxes
If you make changes to the settings using the buttons, edit boxes or check boxes, these changes will only be made to all the selected tables for which the setting is relevant.
Changes to edit boxes will only be done if the change is valid. This is shown by the tick alongside edit box
Changes to check boxes will only be done if set to empty or ticked (not blacked out).
TIP: you can also change the settings for the Rows, Columns and Quantity by dragging an entry from the entry list and dropping it into the relevant edit box.
The down arrows move and select the next table.
Note that format settings may be restricted depending on the type of table selected. See Formats overview for details of individual format settings.
Only entries with a response list can be used as the columns.
Only entries with a value can be used as the quantity weight.
Note that grid tables using single-coded or multi-coded rows can be transposed (rows and columns switched).
If the project (or Reflect database) contains a single-coded or multi-coded entry called level (in CL $level) then this is available as a pull down menu.
The response selected will be used as an additional filter to any which would otherwise be set on a table.
Level is often used in trailer surveys.