Disable equal or lesser scale points in one statement of matrix table based on another statement in same table | XM Community
Skip to main content
Solved

Disable equal or lesser scale points in one statement of matrix table based on another statement in same table


adawson
Level 1 ●
Forum|alt.badge.img+1

Hi, I have a matrix table where I’m asking respondents to select what scale level they are at today, and what their goal scale level is. (Today and Goal being the two statements.) I would like to set up logic where if they select one level for “today”, they cannot choose the same or lesser level as goal. My statements are set up as the columns, and the scale points as the rows (due to formatting). 

 

Best answer by Shashi

This validation can be added by making today and goal as statement and level as scale point. Use transpose option to convert it in the required look and feel. 

Now add custom validation that goal (recode) is greater than today recode (pipe in the selected recode for statement today in textbox of condition).

View original

4 replies

Shashi
Level 8 ●●●●●●●●
Forum|alt.badge.img+32
  • Level 8 ●●●●●●●●
  • 633 replies
  • Answer
  • October 14, 2023

This validation can be added by making today and goal as statement and level as scale point. Use transpose option to convert it in the required look and feel. 

Now add custom validation that goal (recode) is greater than today recode (pipe in the selected recode for statement today in textbox of condition).


adawson
Level 1 ●
Forum|alt.badge.img+1
  • Author
  • Level 1 ●
  • 6 replies
  • October 16, 2023

Hi, thank you @Shashi , unfortunately I have it set up this way due to the formatting. With the bullets and amount of information the client has asked be in each level on the left, placing those scale points across the top in columns instead of rows throws the formatting off making it look messy and uneven. 


TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • 5926 replies
  • October 16, 2023

@adawson,

It seems there is a misunderstanding. Based on your original description your question is already transposed as @Shashi recommends, and therefore his solution will work - you just need to add the custom validation.  The condition would look like:

Goal (recode) is greater than ${q://QIDx/SelectedAnswerRecode/1}

where QIDx is the QID of your question.


adawson
Level 1 ●
Forum|alt.badge.img+1
  • Author
  • Level 1 ●
  • 6 replies
  • October 16, 2023

WONDERFUL! That did it! I appreciate you guys!!


Leave a Reply