Hello,
I have data that is in checkbox format (i.e. check all that apply) and I want to recode those checks to different values/weights. I've done this with the 'recode values', e.g. making the first tickbox worth 3, the second 4, the third also 4, etc.
However, when I export the data (excel, 'Split multi-value fields into columns', I only get data values that are 1 or blank (sample below has all 3 items ticked, only two variables show up, #1 and #3), and one variable field is deleted. Furthermore, the actual weighting/score that I asked qualtrics to code it into is appended to the variable name instead.
If I don't split the multi-value fields, I am also missing an entry, in this case the column for the overall item reads '3,4'. The only way I can get all three data points to export is if I have three different weights/scores, and even then I still get 1 and blanks for the data and the scores appended to the variable names.
What am I doing wrong? This seems like it would be straightforward?
edit: I also tried making a brand new survey and the same thing happens
Best answer by Kate
View original