Rows, Columns and Edges tabs (askiaanalyse)

Rows, Columns and Edges tabs (AskiaAnalyse)

This page contains the following sections:

Concepts

The rows, columns and edges tabs in the table definition window display the questions that will appear in your charts and tables. Items placed in the rows will appear on the vertical axis of your table, those in the columns will appear on the horizontal axis, and those on the edges will appear at the edges. For example, if you have a Gender question in the rows, and an Age question in the columns, the table or chart will display the responses to Age across the top, crossed by the responses to Gender along the side of the table.

From the rows, columns and edges tabs you have access to a wide range of controls to customise the format of your questions:

through the context menu of commands, which is described below,
for questions, through the associated question properties sheet,
for individual responses to questions, through the associated response properties sheet.

Adding questions to a row, column or edge

To place a question in the rows, columns or edges of your table, simply drag the question from the questionnaire list into the appropriate tab. You can freely drag and drop items between the rows, columns, and edges tabs, until the questions are positioned as required.

If you only want to include certain responses, double-click the question, select the desired responses and drag them into the rows tab; only these responses will be selected.

You can drag and drop an entire loop, or just the first question of the loop, by holding down CTRL as you drag. This saves time when you want to render a table at the interview level, as it avoids the need to change the table definition's level to the relevant loop, drag it, then re-switch the level. For more information, see the section on levels.

You can also drag individual responses (or groups of them, by selecting multiple ones) from the distribution window at the bottom of the question tree:

Normally, this creates a new question according to the response you dragged.
If you drop a selection of two or more responses onto the question they belong to, this will create a group containing the selected responses.
If you drop one or more responses onto a question or a response in the custom setting column, this will create a temporary sub-population with the selected response(s).

The following columns appear in the rows, columns and edges tabs:

Questions: Displays the question titles. Click the following icons to view and hide the responses for a question:
- Show the responses;
- Select responses to display. Each response option may be selected or de-selected from display in the table by toggling the checkbox next to the response option.
- Hide the responses
Value: Displays the values for each answer category for graded variables, or when numerical calculations have been authorised.
Sort: Indicates whether an answer category will be sorted or not. To change this option, right-click the response and select sort, then yes or no.

Note: by default, answer categories are sorted, except for don't know and not asked answers.
Custom setting: Displays the name of the sub-population, weighting or other settings specifically applied to the question or response. If the caption of the question/response is edited, "caption" is displayed in this column; any changes to formatting (e.g. bold, italic) are also shown.

Note: The total for the question, by default, is calculated without reference to the options selected for display from the number of valid responses given and it therefore may include answers not shown. If you wish to base the total for the question only on those answers selected, then go to the General tab and select Use question base as the Universe, then, in Calculation options select the checkbox option Make the question total an "All selected responses".

Useful short cuts

These actions can allow you to perform tasks quickly when working within the rows, columns and edges tabs:

Maximise the table definition window by double-clicking the top of the frame as an alternative to clicking the maximize button
Send a question directly to the rows by clicking on the name of the question in the questionnaire panel to the left, then pressing ALT+R
Send a question directly to the columns by clicking on the name of the question in the questionnaire panel to the left, then pressing ALT+C
Send a question directly to the edges by clicking on the name of the question in the questionnaire panel to the left, then pressing ALT+S
Open the property window for a question, by double-clicking the name of the question.
Open the property window for a response, by double-clicking the response.
Access commands for questions or responses by right clicking on the question or any response in the question (see Context menu of commands below).
Select all of the questions in the list by clicking any question in the list then pressing CTRL+A.

Context menu of commands (right-click menu)

The context (right-click) menu contains the following commands:

Command	Description
Cut	Remove the selected element, and place it on the clipboard (`CTRL+X`).
Copy	Copy the selected element to the clipboard (`CTRL+C`).
Paste	Paste an element from the clipboard (`CTRL+V`).
Paste presentation	Paste the structure and formatting (bold, colour, groupings, captions, etc.) of one question to another question (`CTRL+SHIFT+V`).
Paste structure	Paste the structure (that is, any grouped and calculated responses) from one question to another without over-riding the captions of the responses.
Paste captions	Paste captions from Microsoft Word or Excel, replacing the selected response captions. This allows you to apply a large number of text changes to variables or code captions very quickly.
Paste factors	Paste the factor values (from another question, a text file or an Excel file) to the selected question.
Group	Group and hide: Group two or more response items together. The items you grouped together are placed into the new group, and are de-selected, so they will not appear in the tables/charts (although you can manually select them again if you change your mind). This command is available only if you have selected at least two response items. Group and show details: Group two or more response items together. The items are placed into the new group, and remain selected, so they will still appear in the tables/charts (although you can manually de-select them if you change your mind). This command is available only if you have selected at least two response items. Group and leave: Group two or more response items together. The items are placed into the new group, but also remain as separate items in the response list. This command is useful where you intend to include a response in more than one group, as the response remains in the list to be grouped again. By default, the individual items outside of the group remain selected, so they will still appear as separate items in the tables/charts, while the items within the group are not selected, so these items will not appear in the tables/charts (although you can manually select/de-select responses as you wish). This command is available only if you have selected at least two response items.
Split	Split a grouping you have previously made into separate response items.
Numeric	Create a distribution or intervals.
Remove	Remove a question from the tab (so it will not appear in the table/chart).
NR/NA	Select or de-select the don't know (DK) and/or the not asked (NA) categories for all the selected questions.
Sort	Determines whether or not the responses will be sorted. Select `yes` or `no` as appropriate.
Advanced sort...	Allows you to define advanced sort options, such as the method of sorting that is used (by default, items are sorted with respect to the total).
Reset response order	Resets the answer categories to the order in which they were created.
Add calculated response	Add an additional category to the selected question, calculated on table execution. Example of a calculated response: In `caption`, enter a description of the new category. Double-click the first category: the value {1} then appears. Enter the `-` sign. Double-click the fourth category: the value {4} appears Select `calculation of percentages with the base`. Example of mean number of citations: In the caption, enter a description of the new category. Insert the following script: SumAll / Base Select `appears as a statistic`. Note: You can modify the number format specifically for this calculated answer. To do this, click `number formatting...`. The settings you make here will over-ride the properties defined for the response to this question. Note: Calculated responses do not, by default, pick up any custom settings (e.g. sub-populations) of their constituent modalities. However, this result can be achieved by using AskiaScript within the calculation arithmetic calculation type. For example, the following script displays an average, taking into account the custom settings on the constituent modalities: `dim dTotal = 0 dim j For j = CurrentTable.StartY+1 to CurrentTable.StartY+4 dTotal = dTotal + CurrentTable.GetCell(CurrentCell.x,j).Value Next j return dTotal / 3`
Add sum of all responses	Add the sum of all the categories to the table/chart rows, columns or edges, as appropriate. To modify the default wording, total, see wording for sum of all answers.
Modify	Allows you to edit a previously defined calculated response.
Locate	Locate the question in the questions list (in other words, the question will be selected and displayed in the tree view in the left-hand pane).
Col-sig naming...	Allows you to specify a text string either of single letter codes or short text strings to identify the columns referred to in column significance test results. A sequence of single letter codes are written as one string, e.g. "ABCDE". A sequence of short multi-character strings is written with semicolons to delimit them, e.g. "Tot;A1;A2". One letter or string must be specified for each response option.
Col-sig testing...	Note: This option is only available in the `columns` tab. This option applies when you are using the `column sigificativity on closed` calculation type. It allows you to specify which columns will have column significance testing carried out them in the table definition, instead of in the tab template settings.This allows you to have fewer saved tab templates, as you can set the column significance options in the tab definition instead. In addition, since these options are stored in the tab definition, they will be saved in any profile or a portfolio to which you save the tab definition. Animated example of usage. When you select this option, you will be asked to enter the column testing strings that define which columns will be tested. You should separate columns with commas. For example, `A:B, C:D`. Note that in the advanced options for the `column significativity on closed` calculation, you should set `test each column against` to `specify columns in column profile`.
Find	Opens the find dialog to allow you to search for occurrences of a text within the questions or answers defined in the current `rows`,`columns` or `edges` (`CTRL+F`).
Properties	Allows you to define of the properties of the selected question or response. This includes sort and weighting options. You can also double-click a question title to open the properties page for that question.
Save profile	Save the current question/response definition to the indicated profile.
Save profile as	Save the current question/response definition as a new profile.

Create your own Knowledge Base