Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Show in a Ranking only most rated options (4 and 5 /5) of an Array question

  • dgvilalta
  • dgvilalta's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 6 months ago #223146 by dgvilalta
Hi, I need to build a ranking question taking the most valued options of a previous Array question. 
Something like this:
ARRAY QUESTION:
How interesting are these books for you? 1= not interesting at all and 5= the most interesting I´ve ever read

                    1    2     3      4       5
Book 1.      X
Book 2                             X
Book 3                                      X                     

RANKING QUESTION

Rank these books in order or preference
Book 2
Book 3   

Can anybody help me, pease'
Thanks and regards


Please help us help you and fill where relevant:
Your LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
Own server or LimeSurvey hosting:
Theme:

==================
[Write here your question/remark] Please help us help you and fill where relevant:
Your LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
Own server or LimeSurvey hosting:
Theme:

==================
[Write here your question/remark]
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 6 months ago #223147 by holch
To answer this you will need to give a couple more details:

Who do you define "most valued" options?
How many options should be taken into consideration?
What happens if they are all equally valued?
What happens if you have 1 valued "1" and 2 valued "2". Are those two still to consider?

"most valued" could be anything or nothing.

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
  • dgvilalta
  • dgvilalta's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 6 months ago #223149 by dgvilalta
Thanks a lot for the quick response, Holch. Here you have more details:
  • I have three questions at the beginning of the survey with the same structure:
A1. How interesting are these books for you? 1= not interesting at all and 5= the most interesting I´ve ever read
                    1    2     3      4       5
Book 1.      X
Book 2                             X
Book 3                                      X           

A2. How interesting are these films for you? 1= not interesting at all and 5= the most interesting I´ve ever watched
                 1    2     3      4       5
Film 1.      X
Film 2                             X
Film 3                                      X           

A3. How interesting are these magazines for you? 1= not interesting at all and 5= the most interesting I´ve ever read
                           1    2     3      4       5
Magazine 1.      X
Magazine 2                             X
Magazine 3                                      X           

Participant have to rate them form 1 to 5. 
  • Then, what I need is to take the options rated by participants with 4 or 5 and put them in a ranking question in order to select the 3 most relevant for her/him.
What I have tried is:
  • Create a hidden equation question for capturing the options rated with 4 or more. With this description:
{M1_SQ001=(if(A1_SQ001>=4, ""))}{M1_SQ002=(if(A1_SQ002==4,""))}{M1_SQ003=(if(A1_SQ003==4,""))}{M1_SQ004=(if(A1_SQ004==4,""))}{M1_SQ005=(if(A1_SQ005==4,""))}{M1_SQ006=(if(A1_SQ006==4,""))}{M1_SQ007=(if(A1_SQ007==4,""))}{M1_SQ008=(if(A2_SQ001==4,""))}{M1_SQ009=(if(A2_SQ002==4,""))}{M1_SQ010=(if(A2_SQ003=="A2", "5",""))}..... 
  • Create a second hidden multi question (M1) for taking the selected options easily
  • Try to capture the selected options from M1 in the ranking question with Array filter functionality.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 6 months ago #223150 by holch
Why don't you attach a LSS file with what you have done so far to this post?

Create a copy of your survey, delete anything that isn't relevant for this problem, export it as LSS file and upload it here.

Also mention with which version of LS this was created, because you can open files created in LS4/5 in LS3 (which is one of the reasons why we ask about your LS version when you start a post - and which you ignored).

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
  • dgvilalta
  • dgvilalta's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 6 months ago #223158 by dgvilalta
Thanks you very much.
Here you have the survey.
We use a hosted version of Limesurvey Cloud: 3.27.24
 

File Attachment:

File Name: limesurvey...7659.lss
File Size:38 KB
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 6 months ago - 3 years 6 months ago #223159 by Joffm
Hi, there are a few issues in your example.

1. Your equation to set the hidden multiple question is not correct
You did not set the subquestion to TRUE if the value in the array was greater 3.
Should be
{M1_SQ001=if(A1_SQ001>3,"Y", "")}
...



2. There were no answer options in your ranking question.
Please read this again
[url] www.limesurvey.org/manual/Question_type_...rray_filter_style.29 [/url]
and pay attention to the paragraph in the box with the exclamation mark.

And you have to set a relevance equation in your ranking question (if less than three items were rated >3)

Here my solution
 

File Attachment:

File Name: limesurvey... (2).lss
File Size:41 KB


Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 3 years 6 months ago by Joffm.
The topic has been locked.
  • dgvilalta
  • dgvilalta's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 6 months ago #223161 by dgvilalta
Perfect, Joffm. Now, it works!!

Thank you very much.
The topic has been locked.
Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose