Help with Constant Sum | XM Community
Skip to main content
Solved

Help with Constant Sum

  • June 7, 2023
  • 8 replies
  • 353 views
J
Level 2 ●●
Forum|alt.badge.img+2

I am trying to create almost like an Order Quote with Qualtrics and am stuck on figuring out a way to display the inputted values from a Constant Sum question. I am trying to take those inputted values (not the Total) and display them at the end of the survey. The values are used for “Quantity” of a product and I want to display them for the customer at the end.

Best answer by TomG

I am still kinda a novice at Qualtrics, how would I go about doing this? I have added javascript to a Question before, but not applying it to Piped Text etc. Thanks

Let’s say you’ve piped the results into a table with 31 rows. You would have cells like this:

<td class="cspipe">${q://QID1/ChoiceNumericEntryValue/x1}</td>

To hide the rows with blank pipes:

jQuery("#"+this.questionId+" .cspipe").each(function() {
  var cspipe = jQuery(this);
  if(cspipe.text()=="") cspipe.parent().hide();
});

In this example the parent is a table row. However, I’ve written it so it would apply to any type of parent/child element relationship (e.g., <tr><td>, <div><span>, <li><span>, etc.).

Nikkki

8 replies

krbhavya
Level 6 ●●●●●●
Forum|alt.badge.img+20
  • krbhavya
  • Level 6 ●●●●●●
  • June 7, 2023

Hi,

As far as i understand you want to embedded the Constant Sum question values in the end of survey. If so you can simply pipe in the value

 

 
 
Bhavya Kumar
J
Level 2 ●●
Forum|alt.badge.img+2
  • jqm7007
  • Author
  • Level 2 ●●
  • June 7, 2023

Since my Constant Sum question is a “Carry Forward...” statement it doesn’t give me an option to pipe just the values for some reason. It only allows me to utilize the Total or the Highest or Lowest value.

TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • TomG
  • Level 8 ●●●●●●●●
  • June 7, 2023

Since my Constant Sum question is a “Carry Forward...” statement it doesn’t give me an option to pipe just the values for some reason. It only allows me to utilize the Total or the Highest or Lowest value.

You can pipe the values from the Constant Sum.  When you pipe, select the question then the row label (immediately after the ‘row label - Description). The pipe will look something like: ${q://QIDnn/ChoiceNumericEntryValue/x1}

J
J
Level 2 ●●
Forum|alt.badge.img+2
  • jqm7007
  • Author
  • Level 2 ●●
  • June 7, 2023

Since my Constant Sum question is a “Carry Forward...” statement it doesn’t give me an option to pipe just the values for some reason. It only allows me to utilize the Total or the Highest or Lowest value.

You can pipe the values from the Constant Sum.  When you pipe, select the question then the row label (immediately after the ‘row label - Description). The pipe will look something like: ${q://QIDnn/ChoiceNumericEntryValue/x1}

That works, the issue I have is since I have 31 possible answers I technically add all 31 piped answers. Is there a way to remove the null values so that there isn’t a bunch of extra spacing in my message?

TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • TomG
  • Level 8 ●●●●●●●●
  • June 7, 2023

That works, the issue I have is since I have 31 possible answers I technically add all 31 piped answers. Is there a way to remove the null values so that there isn’t a bunch of extra spacing in my message?

You can use JavaScript to modify the format of the piped results. You’ll want to format your message so that all the piped values are inside an element (probably <span> or <td>) with the same class name so you can find them.

J
Level 2 ●●
Forum|alt.badge.img+2
  • jqm7007
  • Author
  • Level 2 ●●
  • June 8, 2023

That works, the issue I have is since I have 31 possible answers I technically add all 31 piped answers. Is there a way to remove the null values so that there isn’t a bunch of extra spacing in my message?

You can use JavaScript to modify the format of the piped results. You’ll want to format your message so that all the piped values are inside an element (probably <span> or <td>) with the same class name so you can find them.

I am still kinda a novice at Qualtrics, how would I go about doing this? I have added javascript to a Question before, but not applying it to Piped Text etc. Thanks

TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • TomG
  • Level 8 ●●●●●●●●
  • Answer
  • June 8, 2023

I am still kinda a novice at Qualtrics, how would I go about doing this? I have added javascript to a Question before, but not applying it to Piped Text etc. Thanks

Let’s say you’ve piped the results into a table with 31 rows. You would have cells like this:

<td class="cspipe">${q://QID1/ChoiceNumericEntryValue/x1}</td>

To hide the rows with blank pipes:

jQuery("#"+this.questionId+" .cspipe").each(function() {
  var cspipe = jQuery(this);
  if(cspipe.text()=="") cspipe.parent().hide();
});

In this example the parent is a table row. However, I’ve written it so it would apply to any type of parent/child element relationship (e.g., <tr><td>, <div><span>, <li><span>, etc.).

J
J
Level 2 ●●
Forum|alt.badge.img+2
  • jqm7007
  • Author
  • Level 2 ●●
  • June 8, 2023

I am still kinda a novice at Qualtrics, how would I go about doing this? I have added javascript to a Question before, but not applying it to Piped Text etc. Thanks

Let’s say you’ve piped the results into a table with 31 rows. You would have cells like this:

<td class="cspipe">${q://QID1/ChoiceNumericEntryValue/x1}</td>

To hide the rows with blank pipes:

jQuery("#"+this.questionId+" .cspipe").each(function() {
  var cspipe = jQuery(this);
  if(cspipe.text()=="") cspipe.parent().hide();
});

In this example the parent is a table row. However, I’ve written it so it would apply to any type of parent/child element relationship (e.g., <tr><td>, <div><span>, <li><span>, etc.).

Ended up adding the JS to the template itself, Thanks so much Tom!

Terms & ConditionsAccessibility statement