Creating Embedded Data calculations for Multi-Select Question
Is it possible to create an embedded data or “calculated column” that summarizes a multi-select question?
For example:
Here is a multi-select question’s recoded values:
When you select Access/View (5) and Change (2), it will show in the export data “5,2”
Is there a way to create an embedded data that will add all of them? I am a novice on JS, and was trying to look for straight forward calculations.
Appreciate the help!
Page 1 / 1
Hello @Nogstai!
You can call with piped text each individual value from the matrix with a simple adjustment.
For example if you want to obtain let’s say the selections from “Associate / Front-Line Employee)”, Qualtrics gives you the piped text ${q://QID23/SelectedAnswerRecode/1} and if the user selected “Access/View” (5) and “Change” (2), it’ll return “5,2”.
Now, in the piped text you could add an index for each option. Something like ${q://QID23/SelectedAnswerRecode/1/1}.
That second index calls each one of the options in order. So:
${q://QID23/SelectedAnswerRecode/1/1} would bring 0 (none)
${q://QID23/SelectedAnswerRecode/1/1} would bring 5 (access/view)
${q://QID23/SelectedAnswerRecode/1/1} would bring 2 (change)
And so on…
In this scenario you would end up with 50 embedded data (10 statements x 5 scale points)
I recommend utilizing Qualtrics' "score" feature to achieve your desired result. Please refer to the following link for more information on how to use the score functionality.
To implement this for your question, you can follow these steps:
Simply create separate score variables for each option, and Qualtrics will automatically calculate the score based on the selected options. You can then use the score thus calculated by piping it anywhere you need within the survey as below :