Type de question – Tableau (Nombres)
From LimeSurvey Manual
Description courte
This type allows a large array of numbered dropdown boxes with a set of subquestions as the "y-axis", and another set of subquestions as the "x-axis".
You can set a special question attribute to use this question type with checkboxes.
Description générale
The Array (Numbers) question type allows a large array of numbered dropdown boxes with a set of subquestions as the "y-axis", and another set of subquestions as the "x-axis". It provides for a very large display of question and answers. By default the dropdown box contains the numbers from 1 to 10, however this can be changed by adjusting the advanced question settings.
The behavior is like this:
- If you only specify a minimum value the range will adjust as min value + 10
- If you only specify a maximum value, the range will be 1 and maximum value.
- When both minimum and maximum value are present and if the minimum value is greater than the maximum value, no dropdown box will be displayed otherwise it works as usual.
Download english sample question: DP_-_Array_Multi_Flexi_Numbers.csv
You can set a special question attribute to use this question type with checkboxes:
Download english sample question: DP_-_Array_Multi_Flexi_Numbers_Checkbox.csv
Les options (paramètres généraux)
Obligatoire
Description
Cette option permet aux administrateurs de l'enquête de demander à leurs répondants de répondre à certaines questions de l'enquête. Si les questions obligatoires ne reçoivent pas de réponse, les répondants ne pourront pas poursuivre. Si vous avez une question comportant plusieurs sous-questions et que vous souhaitez répondre à certaines sous-questions seulement, utilisez l'attribut minimum Answer situé sous l'onglet Logique.
Options disponibles
- Activé - Il faut répondre à la question avant que le participant puisse passer à la page suivante - l'option de réponse « Pas de réponse » n'est jamais affichée.
- Soft - Si la question n'obtient pas de réponse, un avertissement s'affiche lorsque vous essayez de passer à la question. la page suivante - cependant, le participant peut choisir d'ignorer l'avertissement et de continuer. Notez que l'option « Pas de réponse » est toujours affichée (si elle est activée dans les paramètres de présentation de l'enquête)
- Désactivé (par défaut) - La question peut rester sans réponse
Validation (using regular expressions) (preg_validation)
Description
This option lets you specify a regular expression with which you can validate all the parts of a question.
If any question or subquestion value does not meet the validation requirements, the background colour of the text entry field will be changed to red so that users can easily see which parts of the question need to be corrected. Thus, you can do on-page validation. In this way you will not need to wait for the user to click on the submit button to validate the respective question.
Valid values
- Any valid regular expression
Example
- Click here to check multiple examples.
Condition (previously "Relevance equation")
Description
If the result value of the condition is "1" or "true", the question is "relevant" in the survey context, i.e. it is shown to the survey participant. If not, the question is hidden. Any survey question allows you to specify a relevance equation. This function is the successor of conditions and supports much more complex conditional logic.
Syntax Highlighting
Whenever you save the condition, it is evaluated and syntax-highlighted. Any errors will be color coded so that you can quickly detect and fix them.
Valid values
- Any condition that makes use of the ExpressionScript syntax, without surrounding curly braces.
Examples
Here are good examples of syntax highlighting.
Advanced settings
Answer width (answer_width)
Description
This value sets the answer column width by using a percentage system. For example, if you type in this field 40, then 40 percent of the width of the question will be used for answers. The remaining width will be equally divided between the subquestions.
Valid values
- Any integer value from 1 to 100.
Maximum value (multiflexible_max)
Description
Multiflexible_max is available only in the Array (Numbers) question type.
This sets the maximum numeric value for the dropdown lists.
Valid values
- Any integer value
- Any number
- Any SGQA code
- Any question code (variable name)
- Any equation, using the Expression Manager syntax, without the surrounding curly braces.
Example
To set a dropdown box from 1 to 10, type in this box "10".
Minimum value (multiflexible_min)
Description
Multiflexible_min is available only in the Array (Numbers) question type.
This sets the minimum numeric value for the dropdown lists.
Valid values
- Any integer value
- Any number
- Any SGQA code
- Any question code (variable name)
- Any equation, using the Expression Manager syntax, without the surrounding curly braces.
Example
To set a dropdown box starting from 7, set this attribute to 7.
Step value (multiflexible_step)
Description
Only available in Array (Numbers) question type. Sets the numeric step value for the dropdown lists.
Example
To set a dropdown box starting at the number 2, and going to 10 in 2's (ie: 2, 4, 6, 8, 10); set this attribute to 2.
Checkbox layout (multiflexible_checkbox)
Description
The checkbox layout is available only within the Array (Numbers) question type. If enabled, the survey respondent will be able to answer the subquestions by ticking the right answer via checkboxes.
This attribute will automatically use multiflexible_min=0, multiflexible_max=1, and multiflexible_step=1, regardless the custom values entered in the respective boxes.
Available options
- On
- Off (default)
Example
If enabled, the array (numbers) question type will look like this:
Insert page break in printable view (page_break)
Description
This attribute is only active when you actually print a survey from the Printable View. It forces a page break before the question.
Available options
- On
- Off (default)
Show in public statistics (public_statistics)
Description
This attribute allows the survey administrator to chose if a particular question results should be displayed to the survey participants after they submitted the survey.
The default setting for each question is 'Off' (=Do not show the question statistics to the respondents). You have to enable this for every single question if you want to show the survey statistics of that (those) particular question(s) to the survey participants after the survey submission.
Available options
- On
- Off (default)
Random answer order (random_order)
Description
This attribute causes LimeSurvey to ignore the existing order of answer options/subquestions, and instead it orders them randomly. This option permits the survey creator to diminish the survey bias. Please note that if a question has subquestions, the order of subquestions will be randomized, not the order of the answer options.
Available options
- Yes - Randomize when participant enters survey
- No (default)
SPSS export scale type (scale_export)
Description
This is used for SPSS export only. This attribute overrides the default scale guessed by SPSS. To learn what the different measurement scales do, please read the related SPSS documentation.
Available options
- Default (default)
- Nominal
- Ordinal
- Scale
Array filter (array_filter)
Description
The Array filter setting allows you to use any multiple choice question to select or set which responses are displayed in a subsequent list, array or multiple choice question.
- Multiple choice
- Multiple choice with comments
- Multiple short text
- Multiple numeric
- Array (5 point, 10 point, Yes/No/Unknown, Increase/Same/Decrease, Column)
- Array (Dual Scale, Text, Numbers)
- Ranking
Furthermore, each of these question types can be filtered.
The only exception is Array (Column), which can filter other questions, but not itself.How to set a filter
To set a filter, enter the question code of a multiple options question in the array filter box of the question you are currently editing. The respective question will be used as the source of information for the current question, the selected answers from the previous question being retrieved and used as answer options for the current question. For example, if your source multiple option question code is "Q1", enter "Q1" into the 'Array Filter' box to start the filtering process of the answers. Only the answer options that are selected in question Q1 will be visible in the array_filter-ed question.
Cascading
The selected options can be displayed in cascade. This means that you can select a question which filters another question, which filters another question, and so on.
Array filter example
Let's take a look at the following example to better understand the power of this setting:
In the screenshot from above, we got two questions. The first one is a multiple short text question type, while the second one is an array dual scale question type. The answers you provide in the first question will be listed in the second one. Technically, the answers you provide to the subquestions from the first question are filtered and displayed in the second question.
This example can be downloaded from the following link: limesurvey_group_32.lsg. Import this question group into your LimeSurvey installation.
Array exclusion filter (array_filter_exclude)
Description
The Array filter exclusion setting allows you to use any multiple choice question to select or set which responses are NOT displayed in a subsequent list, array or multiple choice question.
- Multiple choice
- Multiple choice with comments
- Multiple short text
- Multiple numeric
- Array (5 point, 10 point, Yes/No/Unknown, Increase/Same/Decrease, By column)
- Array (Dual Scale, Text, Numbers)
- Ranking
Furthermore, each of these types of questions can filtered.
The only exception is Array by column which can filter other questions, but it cannot be filtered.How to set it up
Enter the question code of a multiple options question in the array exclusion filter box of the question you are currently editing. The respective question will be used as the source of information for the current question, the non-selected answers from the previous question being retrieved and used as answer options for the current question. For example, if your source multiple option question code is "Q1", enter "Q1" into the 'Array exclusion filter' box to start the filtering process of the answers. Only the answer options that are NOT selected in question Q1 will be visible in your question.
Cascading
The selected options can be displayed in cascade. This means that you can select a question which filters another question, which filters another question, and so on.
Example
Let's see together the below example:
In the screenshot from above, we got two questions. The first one is a multiple choice question type, while the second one is a multiple choice with comments question type. The answers you provide in the first question will be excluded from the second one. For example, if you select the ComfortUpdate option (that has the subquestion code 'SQ1') and the Plugin option ('SQ4'), the 'SQ1' and the 'SQ4' subquestion correspondents from the second question will be excluded. In our screenshot, we can observe that only the unselected options in the first question and displayed in the second one.
This example can be downloaded from the following link: Limesurvey_group_array_filter_exclude.zip. Import this question group into your LimeSurvey installation.
Minimum answers (min_answers)
Description
This function can be used to ensure that a user selects at least a certain number of answers in a multiple choice question.
Valid values
- Any integer value above 0
- Any number
- Any SGQA code
- Any question code (variable name)
- Any equation, using ExpressionScript syntax, without surrounding curly braces.
Example
If set to X (a random number), the users can submit the survey form if they select at least X checkboxes. If this option is utilised for ranking questions, this ensures that at least three items are ranked before allowing the respondent to submit the answers/survey.
Maximum answers (max_answers)
Description
It can be used to limit the total number of answers a user can select in a multiple choice question.
Valid values
- Any number value
- Any SGQA code
- Any question code (variable name)
- Any equation, using ExpressionScript syntax, without surrounding curly braces.
Example
If set to 2, the user will only be able to check at most two checkboxes or one checkbox + fill the "Other" field (if any). For the Ranking question type, the participant would be able to select maximum two items.
Question validation equation (em_validation_q)
Description
This is an equation that is used to validate the entire question (e.g, all of its parts collectively for a multi-answer question). If the question fails the validation criteria, then em_validation_q_tip message will be displayed (it uses the CSS style .error). This tip uses the .em_q_fn_validation CSS style, which is hidden by default within template.css.
The main difference between this feature and the subquestion validation equations (em_validation_sq option) is that for this feature, if the question (or question parts) fail validation, then an error message could be shown. For the subquestion validation, each text entry cell (e.g., in an array question type, but it can also be applied to single entry question types) will be styled so that the background color is (light) red.
Valid values
- Any equation that makes use of the ExpressionScript syntax, without surrounding curly braces.
Example
- You want to collect demographic information from users via a multiple short text question, and you want to validate that the user has entered a valid email address and phone number.
This example shows how the question looks with invalid answers:
And here is what it looks like with one invalid answer:
Here is how you edit a question to enter that information:
And here is part of the Show Logic File output that lets you check the accuracy of your expression and ensure that there are no syntax errors:
As you can see, the validation equation tests that both the email and phone number are either empty or match a regular expression filter.
The validation tip only shows the warning message if the phone or email appears invalid.
If you wish to import the example from above into your LimeSurvey installation, download the following .lsq file: Em_validation_q_example.zip.
Tip for whole question validation equation (em_validation_q_tip)
Description
If you are using the question validation equation, you can use this box in order to display an optional message as question tip on how the question has to be filled out.
Valid values
- Any string or equation that makes use of the ExpressionScript syntax.
Example
See the example from the question validation equation wiki section- it shows how the tip can be tailored to show which parts of a multiple short text question fail the validation criteria.
Sub-question validation equation (em_validation_sq)
Description
This is an equation that is used to validate each subquestion (text field) individually. Any text field that does not pass these validation conditions will have its background color turned pink (using the .em_sq_fn_validation CSS style) to highlight the error. Note that this is available in addition to the regular expression-based validation option.
Valid values
Any equation that makes use of the ExpressionScript syntax, without surrounding curly braces.
Examples
For example, if you want to allow only numbers that are a multiple of 3 as answers, the equation would be:
(this / 3) == floor(this/3)
The reserved variable this is automatically replaced by a reference to the active text entry cell.
Tip for sub-question validation equation (em_validation_sq_tip)
Description
If you are using em_validation_sq, this is an optional message/tip that will be displayed if the introduced answer is incorrect.
Valid values
- Any string
Example
- Continuing the example of validating emails, the tip might be "Please enter valid email addresses."