Welcome to the LimeSurvey Community Forum

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

Error in data set after downloading

More
1 year 10 months ago #216413 by zliine
Dear all,

I downloaded my data set as CSV file and had a first look at it in Excel. I noticed the following error:
The question is in the "dual matrix" format with the following answer options and codes...
Antwort-Skala 1, A1 = in der Gegenwart
Antwort-Skala 2, A2 = in der Vergangenheit
this means, that each "Skala" only has one possible answer, however, in my data set, I see that under "Skala 1" the answers A1 AND A2 appear, and the same happens for "Skala 2". See the screenshots attached for clarification. Can someone explain why it shows A1 and A2 although only one option should be available per "Skala" ? This messes up my whole data set.

All the best,
Celine
The topic has been locked.
More
1 year 10 months ago - 1 year 10 months ago #216415 by Joffm
Hi,
Are these codes in the LimeSurvey answer table, too?

Joffm

And you missed to mention your LS version and where hosted.

 

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 1 year 10 months ago by Joffm.
The topic has been locked.
More
1 year 10 months ago #216419 by jelo
My first guess would be an import issue with CSV and Excel (where the regional list separator is not matching the CSV format).

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
More
1 year 10 months ago #216424 by holch
I go with Jelo!

How does the same section look like in the Limesurvey backend where you can see the responses?

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
More
1 year 10 months ago #216467 by zliine
Dear all,
I checked and the error appears in the LimeSurvey answer table too. For some answers, it's correct and for others it's not (see screenshots attached).
I use LiemSurvey Version 3.26.2 210503 (?) hosted in Germany.

All the best,
Celine
The topic has been locked.
More
1 year 10 months ago #216473 by holch
Hmm, your second screenshot looks odd. Why does Limesurvey show the answerlabel and the answer code in the first column, but not in the second column?

Because for the first screenshot the table shows label and code for both, but in the second one, where there are problems, it only shows the code.

Do you have any equations in your survey? My suspicion is that you have an error in the your equation and instead of checking if the answer is A2 you attribute A1 to the answer via equation.

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

Lime-years ahead

Online-surveys for every purse and purpose