Hello,
I haven't found the answer I'm looking for in other posts here so thought I'd try asking myself - I'm trying to grab the count of selections made underneath the column "Active/Contributing Member" in the matrix table pictured below so I can multiply it by a certain value. Trying to do the same for the second column. So if there are three different statements chosen under Active/Contributing Member...., the count should = 3. If 5 are chosen under chair, the count = 5. I need to store these values in two variables so I can access them later in the survey.
Unfortunately the piped text menu option "Selected Choices Count" sums selections across rows, not columns. I essentially need the same thing but for columns. Does anybody have any pointers on how I can do this? My guess is I might be able to add a click counter in the matrix table's javascript but not sure how I'd pass the variables to another page on the survey...
Appreciate your help.
Matrix Table: Count of selected choices across a column of statements
+2Best answer by darelS
I think you can do it via Javascript. Just pipetext the selected choices for the column then split it then get the length.
sample:
var count = "${q://QID1/ChoiceGroup/SelectedChoicesForAnswer/1}".split(",").length;
+30I haven't tested this myself, but you might try the Transpose table option and see if counts sums the selections the way you want after applying that.
+2I think you can do it via Javascript. Just pipetext the selected choices for the column then split it then get the length.
sample:
var count = "${q://QID1/ChoiceGroup/SelectedChoicesForAnswer/1}".split(",").length;
Yes below is working fine.
var count = "${q://QID1/ChoiceGroup/SelectedChoicesForAnswer/1}".split(",").length
+2+4This is great and exactly what I'm looking for darelS Sateesh avunjian . Apologies for the following question is very basic and demonstrates how much of a noobie I am.
Where is the best place to add the JS creation of this new variable that counts the number of statements chosen for a particular column? Would that during hte UnLoad phase of the same question?
If so, would the full syntax look something like the following?
Qualtrics.SurveyEngine.addOnUnload(function()
{
/*Place your JavaScript here to run when the page is unloaded*/
var count_var = "${q://QID1/ChoiceGroup/SelectedChoicesForAnswer/1}".split(",").length
Qualtrics.SurveyEngine.setEmbeddedData("embedded_var_name", count_var)
});
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.