rsh started following Dealing with Non-Responses to Open-ended Survey Questions
rsh posted a topic in NVivo 11 for WindowsIn my office, we regularly code the responses to open-ended survey questions using NVivo. One issue we not have been able to resolve is the best way to deal with non-responses to open-ended survey questions when importing survey data into NVivo. Ideally, when viewing the node for each open-ended question in list view in NVivo, we would like the count of references to display the correct number of valid responses to each survey question (i.e. we would like the reference count to exclude non-responses). Even if we import all non-responses as blank cells (and replace all --99 missing values from Qualtrics with blanks), the reference count for each question node in NVivo references the total number of rows in the spreadsheet for each question (including blank cells), rather than the number of valid responses. We have found a workaround to filter out the non-response data from each question node using a separate classification sheet which indicates whether each respondent answered each question. However, this process has been very time intensive. If anyone has a solution to this issue, your advice would be very much appreciated!