Constant Sum Custom Validation - Compare 2 constant sum question choices | XM Community

Constant Sum Custom Validation - Compare 2 constant sum question choices

  • 21 June 2022
  • 1 reply
  • 14 views

Badge +2

I want to compare 2 constant sum question choices. Both the questions having same choices. Each choices value of this question should be less than or equal to the previous question choices value. If not, participant cannot move forward and it should throw error message


1 reply

Userlevel 7
Badge +30

This can be done by piping the value from the first question into the custom validation of the second question.
For example, let's say your two questions had the following race/ethnicity categories.
image.pngFind the QID values string to pipe in the value from each line in Q1. Temporarily pipe it into a place on your survey so you can copy the full string, and paste it into a Word file or something similar. There are a lot of different things available to pipe for each question, so make sure to select the Entry Values, which are further down the list of options, and not question text, descriptions, or choices. The string for Entry Values should look something like this: ${q://QID106/ChoiceNumericEntryValue/1}. Repeat this for each line in Q1.
image.png
Then in Q2, set up custom validation for each line, similar to what's shown below (note that it only displays a portion of the actual validation). In each text field circled in red you will paste the piped text string from your Word file for the corresponding row in Q1. After you complete and save, make sure to test out each line of the validation thoroughly.
image.png

Leave a Reply