Welcome to the LimeSurvey Community Forum

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

scoring answers in array by column question type

  • aleks!
  • aleks!'s Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 4 months ago - 1 year 4 months ago #244199 by aleks!
Please help us help you and fill where relevant:
Your LimeSurvey version: 5.6.25
Survey theme/template: Vanilla Theme
==================
Hi!
I'm a relatively new to LimeSurvey so the answer to this might be very obvious to some but I couldn't find the info elsewhere: I'm setting up a survey that contains an assessment part for which I am using the array by column question type. So, this assessment contains sub-questions with multiple answer options, but there's only one correct answer for each sub-question. At first I thought that I could add an assessment value to each correct answer, but this does not take into account the column under which the answer is selected (there's only one correct answer per column and per row, and each correct answer increases the participants' score by 1).
From what I've found, I can instead set this condition:
{sum(
IF(Q1_SQ001 =="A",1,0),
IF(Q1_SQ002=="B",1,0),
IF(Q1_SQ003=="X",1,0),
IF(Q1_SQ004=="Y",1,0)
)}
However, I could not find any information about whether this score will be stored in the final data file, or how I would need to go about storing the score, or if it's even possible to store the score or whether it's just something used for feedback purposes. How would I go about storing the score with the rest of the data (if that's possible)?

 
Last edit: 1 year 4 months ago by aleks!. Reason: typos

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 4 months ago #244200 by holch
Assessment scores are NEVER stored in the database. So if you would use the traditional "assessment" feature, you would have to store this in a hidden question or something anyway.

What you do is calculate your score in a (hidden once you tested and it works) equation question. This way it is stored in the database. You can check this if you activate your survey and put in some data. You'll see that the value will be stored in this equation question and you can work with it later (or even within the same survey).

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 4 months ago - 1 year 4 months ago #244201 by Joffm
Hi,
you do not "set a condition",
you create a question of type "equation" with this function.

Please remove the typos.
"X" 150" ???
" Y " ???

Then the value is stored with the code of this question (as all other questions)

Joffm 
​​​​
@holch beat me

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 1 year 4 months ago by Joffm.

Please Log in to join the conversation.

  • aleks!
  • aleks!'s Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 4 months ago #244202 by aleks!
Ah ok thank you, this clarifies things. I'll check that out!

Please Log in to join the conversation.

  • aleks!
  • aleks!'s Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 4 months ago #244203 by aleks!
Oops, I don't know where those numbers came from, my bad! I fixed the typos now.
Ah ok, good to know. Thank you!

Please Log in to join the conversation.

  • aleks!
  • aleks!'s Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 4 months ago #244271 by aleks!
Since I am using array by column and since the answers are selected with radio buttons, I was wondering if Q1_SQ003 =="X" was the right way to reference the answer . Wouldn't referencing the answer option as "X" only work for text answers? I was looking at the manuals and could not find how to reference the answer variable. I tried Q1_SQ003==Q1_A01 (assuming that the code for answer "X" is A01) but then I get an error message for having an undefined variable.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 4 months ago #244275 by holch
You need to use the answer codes you are using.

If the relevant answer code is A01, then you need to use Q1_SQ003=="A01".

Q1_A01 doesn't exist in Q1_SQ003, this is why you get the "undefined variable" error. The variable is not Q1_A01, but A01. And you need "" as you seem to use alphanumeric codes and not just numbers.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • aleks!
  • aleks!'s Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 4 months ago #244277 by aleks!
Aaaah ok that makes sense, thank you!

Please Log in to join the conversation.

Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose