Validation with ignored selected choices | XM Community
Skip to main content

Validation with ignored selected choices

  • October 13, 2022
  • 4 replies
  • 23 views
S

I need to make a matrix table that adds all selected values for the statements, but ignores two specific non number values that are available for each statements drop down list. the sum of all the values must not exceed 100. If the sum is greater than 100, it must have a validation error or similar pop up to prevent the respondent from continuing. I am fully lost in the best way to approach this problem.

4 replies

Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+46
  • Deepak
  • October 14, 2022

SRL
Can you please give an example or maybe an illustration? To elaborate the use case here.

    TomG
    Level 8 ●●●●●●●●
    Forum|alt.badge.img+27
    • TomG
    • Level 8 ●●●●●●●●
    • October 14, 2022

    SRL ,
    Add a text entry question after the matrix question. Add JS to your matrix question to sum the values and copy the sum to the text entry question. Add custom validation to the matrix question based on the value of the text entry question.
    You probably need to display the current sum to the respondent. There are a number of different approaches. If it were me, I would hide the text entry question and add html via JS to the matrix question to display the sum.

      SuhasM
      Qualtrics Employee
      Forum|alt.badge.img+16
      • SuhasM
      • Qualtrics Employee
      • October 17, 2022

      Wow! Great job on providing a solution to a unique question! 👏

      TomG
      Level 8 ●●●●●●●●
      Forum|alt.badge.img+27
      • TomG
      • Level 8 ●●●●●●●●
      • October 17, 2022

      https://community.qualtrics.com/XMcommunity/discussion/comment/50921#Comment_50921While SRL's situation is unique, the validation need isn't. I've used this technique quite a few times.

        Terms & ConditionsAccessibility statement