Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Meaning of Export data for Multiple choice with comments

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 11 months ago #198356 by holch

@holch : try with array_filter or exclude option.


@DenisChenu: I didn't, because blocka said that there weren't any in the survey. It was also my suspicion, but I need to trust blocka here. I have no further ideas what could lead to this behavior, because I also couldn't reproduce it.

@Blocka: Try with the copy of the reduced survey that you have given us via LSS and check if you can reproduce this. If not: The problem is in some other part of your survey.

Are those responses with "NULL" in the database completed responses or not? One of my suspicion was that these are responses that have not been completed. Not sure if then a "NULL" in the database makes sense. Maybe Denis has more insights on this.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 11 months ago #198357 by DenisChenu

holch wrote: Are those responses with "NULL" in the database completed responses or not? One of my suspicion was that these are responses that have not been completed. Not sure if then a "NULL" in the database makes sense. Maybe Denis has more insights on this.

No,

Seems the same QID … then : you can't have "Y" and null without filtering or subquestions relevance …
(and since i already make an error …)


@Blocka : for reminder : what is your LimeSurvey version ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: holch
The topic has been locked.
  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
3 years 11 months ago #198360 by blocka
Version 3.22.10+200323 when data was collected. Yesterday I updated to 3.22.14+200423

Except for 4 responses, all others have been marked as completed, and of those completed, many show the Y, blank or NULL option for the

Looking through the exported data, the N/A appears in many response rows where the question type is either:

List with comment
Multiple choice with comments

Show "No answer": is enabled on the survey -- but that would only affect List with comment type questions, right?
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose