Hello,
basically my question continues from this thread: www.limesurvey.org/de/foren/can-i-do-thi...d-name-that-have-max

I have several sliders for the same question and I want to collect information about which options were rated the highest and which the lowest.
So far, so good.
But in addition I want to choose one option, when several options are rated identically.

Therefore I need to identify which options are rated the highest and then choose randomly among them (and the same for the lowest rating).

How exactly could I accomplish this?

Thank you very much for your help!

Hi,
in the other thread you saw how you calculate the min value and max value.
Unfortunately LimeSurvey does not support dynamic lists.
So you have to fake this.

A. max.
1. calculate the max value - like
maxValue: {max(that.Q1)}
2. create a string joining all companies with this max value - like
maxString: {join(if(Q1_SQ001==maxValue,"A",""),if(Q1_SQ002==maxValue,"B",""),if(Q1_SQ003==maxValue,"C",""), ...
If the second and the fifth company both have the maxvalue, you may have a string like "BE".
3. create a random number (1- length of the string) and grab the substr - like
maxCompany: {substr(maxString,rand(1,strlen(maxString))-1,1)} (-1, because the first index of substr is "0")

Now you have a random company (the related character) that was rated max.
This you may use for further calculations like relevance or assignments.

B. Min
analogue

Working example (only max)



Joffm

I think Joffm now dreams in Expression Manager syntax.

Thanks, that works great!

Is there also a way to check if the randomization process resulted in two identical results? Basically, can I force the entire statement to repeat if the results from MaxCompany and MinCompany end up identical?

No,
but you could exclude the chosen MinCompany of the process selecting MaxCompany.
Here:
2. create a string joining all companies with this max value - like
maxString: {join(if(Q1_SQ001==maxValue,"A",""),if(Q1_SQ002==maxValue,"B",""),if(Q1_SQ003==maxValue,"C",""), ...
Extend the if-statement
{join(if(Q1_SQ001==maxValue AND minCompany!="A","A",""),if...

Or you validate the question that not all companies have the same rating.
So you avoid minCompany=maxCompany.

Joffm

That is a good solution, thanks a lot for your help.