We ave created a questionnaire with radio buttons. When we export the answers in csv or excel file we only get the responses selected by the user. However we need to get also the value 0 for the non selected answeres (empty one). How can we get them? is there any parameters to set ahead? thanks for your kind help !
Dear Joseph,
Many thanks for your quick reply. When user replies to a question which is using radio buttons, only one answer can be selected. When we export the results of the answers, we get only the ones which has been selected, and the export provides us with the value 1 or 2 or 3 corresponding to the answer etc.. depending on how we set it. So far so good.
On our side, after having extracted all the answers, we will create a report with graphs based on the export and we have some formulas, calculation and weighting which will require to include also the non-selected answers (which should then appear as value 0 in the export).
Hope this clarifies a bit our request and need and again we thank you in advance for your kind help.
Best regards, Gabriel
Hi Gabriel,
When you say you want "to include also the non-selected answers", I suppose this means that your radio-button questions are not required? If so, then indeed in the report the cell for non-selected/answered answers is "blank/empty". In your stats software, you could modify those blank cells to have a zero value, no?
When you say you want "to include also the non-selected answers", I suppose this means that your radio-button questions are not required? If so, then indeed in the report the cell for non-selected/answered answers is "blank/empty". In your stats software, you could modify those blank cells to have a zero value, no?
EDIT.- Upon further thought... as per the doc at: https://docs.moodle.org/310/en/Editing_Questionnaire_questions#Possible_answers
Suppose you have this question:
Required question Yes
What is your favourite drink?
:
1::tea
2::coffee
3::wine
0::none of the above!
2::coffee
3::wine
0::none of the above!
Upon exporting the questions in CSV download, you would get that "0" value you want:
where you have 2 respondents who selected tea (1), 1 respondent who selected coffee (2) and 1 respondent who selected "none of the above!" (0).
Unfortunately 
the current version of Questionnaire does not work as described in that part of the docs. The "::" separator function seems to have been lost at some time over the past years. It's very easy to restore it, just a single line to add in one questionnaire file. I will pull a request so that Mike can fix this reversion.
Please Gabriel, confirm that that would solve your problem.
Joseph