Creating a new formula/variable based off items selected in multiple answer questions

Question

Hi all, I’m wanting to find out a way to create a new variable (via a multiple answer question) so it will tally the number of items participant’s selected. At this moment, the csv data file has their answer like “1, 3, 8, 9” instead of 4.The final option they can select is “I haven’t experienced any” which I’ve coded as 0. I’m wanting to know the number of events people select (minus the final answer), because I have further data regarding the number of events. I know I can manually count each answer, but if I’m collecting 200 participants’ data, this isn’t a very good use of my time.I’ve tried to create a new field/formula, however, it won’t allow me to select the relevant question when trying to put the selections in the formula (i.e., a+b+c, etc.).  Any ideas would be helpful! This is my furst survey so I’m totally lost and don’t even know what phrases I would use to search if someone else had already asked haha. Thanks!

TomG · Accepted Answer

@IzzyS,It isn’t clear to me if you’ve already fielded the survey. If you haven’t, you can pipe the count of selected choices for a MC question into an embedded data field in the survey flow. It would be something like this:Set Embedded Data: Q1count =${q://QID1/SelectedChoicesCount}Branch: IF Q1 Selected Choice Is Equal To I haven’t experienced any  Set Embedded Data: Q1count = 0If you’ve already fielded the survey, you can use a formula in Excel:=IF(A1=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),",",""))+1)

ArunDubey · Answer

you can achieve this using Scoring option of Qualtrics. Please refer below link.https://www.qualtrics.com/support/survey-platform/survey-module/survey-tools/scoring/

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded