I have some questions with a “NA” option and it is set as “Exclude from analysis”. This option value is also recoded as ‘999’ in Qualtrics. Since the legacy exporter will phase out in 2021, recently I start using the new data exporter. Then I notice a different behaviour between two exports. In legacy exporter, these values will be exported as “999” but in the new exporter, those values are really “excluded” and those cells become blank. Since we also want to know the number of responses who chose "NA", it is important for us to get the "NA"/"999" responses in the exported data. Although I can turn off the “Exclude From Analysis” setting, this makes results of Qualtrics report invalid (as it include 999 in calculating means and SD). Is there a way for me to keep those "999" responses in my response data set and keep the Qualtrics report correct? Thanks.

Workaround would be to punch the code as 99 in an ED when the scale is selected.This will you can keep the Qualtrics report intact alongside your requirement.

Responses marked as "Exclude from Analysis" were not included in exported dataset

Responses marked as "Exclude from Analysis" were not included in exported dataset | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded