# Negative number as question code

5 years 1 month ago #96167 by aukevann
aukevann created the topic: Negative number as question code
At the moment a negative number can not be the question code.
This is a real limitation for questions that have plus and negative question answers (i.e. semantic differential).
Now we have to convert the codes to numbers before processing the data in Excel.
Can it be considered to allow this in the future?

Regards,
Auke

5 years 1 month ago #96173 by Ben_V
Ben_V replied the topic: Negative number as question code

a negative number can not be the question code

correct...
The use of underscore is allowed and could be useful in the need of proceed easy changes in a spreadsheet column.

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)

5 years 1 month ago #96175 by aukevann
aukevann replied the topic: Negative number as question code
Yes, but you can't do calculations with it.
If it is negative you can.

3 years 5 months ago #116519 by jonsen
jonsen replied the topic: Negative number as question code
Can somebody tell my why this is? I find it to be good pratise to use negative codes for N/A answers like...

- not applicable
- don't know

What is the limiting factor here? None of the result tables seem to have any UNSIGNED data types...

Best
Jonsen

3 years 5 months ago #116520 by holch
holch replied the topic: Negative number as question code
I guess this has also to do with Expression Manager. When Expression Manager was implemented, the rules for the question codes became a lot stricter.

What you could do is write a new value into an equation question automatically.

E.g. {if(question1==1,-2, if(question1==2,-1, if(question1==3,0, if(question1==4,1,2))))}

Something like that. Then you use the equation instead of the actual question to analyze.

We usually use something like 99, 98, 97, for these cases.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
The following user(s) said Thank You: jonsen

3 years 5 months ago #116521 by jonsen
jonsen replied the topic: Negative number as question code
Thanks for the reply and the workaround! Still, would be interesting to know why this is limited exactly...

3 years 5 months ago #117067 by jonsen
jonsen replied the topic: Negative number as question code

3 years 5 months ago #117070 by Ben_V
Ben_V replied the topic: Negative number as question code
You probably will be interested in this ...

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)

3 years 5 months ago - 3 years 5 months ago #117071 by holch
holch replied the topic: Negative number as question code
Ben, the post is about the question code, as far as I understand it, here we are talking about the answer codes.

So while there is a good chance that it won't be added, it is quite a different topic than in your link.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Last Edit: 3 years 5 months ago by holch.

3 years 5 months ago #117088 by Ben_V
Ben_V replied the topic: Negative number as question code
Oups.. you're right Holch the link is off-topic

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)

3 years 5 months ago #117092 by holch
holch replied the topic: Negative number as question code
No problem. I guess the response will be quite similar to the one for the posted link.

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