Hello!
I have a survey with 100 five-point array questions divided in 10 block (scales). I used the "sum" function to calculate and display the sum of values for each of these 10 blocks of questions, so, at the end of the survey, there are 10 blocks (variables) with sum of values. The blocks are labeled as A, B, C, D, E,...
However, I do not want that respondent see a list of values for each of the ten block, but only the highest one. For example, if respondent have following scores on A=5,6, B=9,2, C=2,03, D=6,6, I want to show only the B instead of showing all of the values. I tried to do it with "max" function, but it shows only the value, not the label as well.
It looks like this:
"Your highest values is 9,2"
but, I'd like to display it as:
"Your highest value in on B=9,2"
So, is there any way to show only the maximum value and corresponding label.
Thank you for any suggestion.
The topic has been locked.