Using Piped Text from Constant Sum Question with Multiple Low / High Values | XM Community
Skip to main content

Hello, I could use some help:
I'm programming a survey with a Constant Sum question to get data on 13 preferred activities. I want to take all statements with the highest and lowest values and use them as piped text for subsequent open ended questions. Looks like I have two issues, and for simplicity's sake let's just pretend that these are my statements and their point allocations:
Apples - 40
Oranges - 40
Lemons - 10
Limes - 10
Celery - 0
Multiple High/Low Values: When I use the following as piped text [${q://QID3/ChoiceGroup/ChoiceWithHighestValue}], only one 'highest value' is displayed, even though there are multiple statements with that high value. Is there a way to use CSS, Javascript, or embedded variables to pipe in all of the 'highest value' statements instead, and then apply those values to individual text box responses? (example: Apples and Oranges both have the highest value in my constant sum, but only Apples comes back in my Piped Text instead of both Apples and Oranges)
Low Values: Currently, the "low values" piped-in are grabbing the 0 and though it's correct that it's the lowest value, I actually want to pull in the statements that have the lowest non-0 value. Is there a way to do that? (example: I want to discuss Lemons and Limes, but my piped text is displaying Celery)
Thank you in advance 😊

Yes, instead of piped text you have to JS to get required results.


https://community.qualtrics.com/XMcommunity/discussion/comment/49193#Comment_49193Okay, I figured as much - but I'm pretty green with coding unfortunately and would need an assist on this.


https://community.qualtrics.com/XMcommunity/discussion/comment/49253#Comment_49253Hi Amanda, did you get an answer? I have the same problem.


If you are interested, I have a function called csRanks that does this.


MaGr I have not gotten an answer (yet), but am very interested in the function that TomG has mentioned - tell us more!


https://community.qualtrics.com/XMcommunity/discussion/comment/49762#Comment_49762You can read all about it here. I believe it is flexible enough to handle just about any type of ranking and piping of constant sum questions that you would want to do. Contact me by direct message for pricing.


Leave a Reply