Expression Manager big 'if' list

Mehr
1 Woche 1 Tag her #170864 von redbeard
redbeard erstellte das Thema Expression Manager big 'if' list
Hi,

Thank you for taking the time to take a look at my question.

I have a question which asks users to pick a choice from a drop down list with 21 answers.
Depending on the answer, I want to give a score between 1 and 3. (score to be saved in DB)


I think it's possible to do this with a long 'if' statement, something like this (I have only put in the first 2 of 21 answers here):
{if(Q8 == 'AGRICULTURE, FORESTRY AND FISHING', '1', if(Q8 == 'MINING AND QUARRYING', '2', '3' ))}
  1. Is there a better way of doing this than a long if statement?
  2. The code above doesn't work - I have tried with and without the '
  3. Rather than using the answer text in the Expression, is it possible to use the Answer code?

Many thanks for any help on this

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
1 Woche 1 Tag her #170865 von Joffm
Joffm antwortete auf das Thema: Expression Manager big 'if' list
Hi,
of course, you have to use the code.
And with only three different scores, it is something like:

{if(Q8==1 or Q8==3 or Q8==13,1,if(Q8==2 or Q8==4 or Q8==12,2,3))}

Best regards
Joffm


Volunteers are not paid.
Not because they are worthless, but because they are priceless
Folgende Benutzer bedankten sich: redbeard

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
6 Tage 12 Stunden her #170901 von DenisChenu
DenisChenu antwortete auf das Thema: Expression Manager big 'if' list
Yes , you can manual.limesurvey.org/Expression_Manager#Conditional_Equations (see manual.limesurvey.org/images/1/1f/Tailoring9.jpg )

But with a lot of if, you can do someting like this :
{join(
if(Q8==1 or Q8==3 or Q8==13,1,''),
if(Q8==2 or Q8==4 or Q8==12,2,''),
if(Q8==1 and Q8==3 and Q8==13 and Q8==2 and Q8==4 and Q8==12)
)}

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .
Folgende Benutzer bedankten sich: redbeard

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha