Hi,
At first I "complain about" this:
You still have these default "A1", "A2",... Codes in your frequency question.
Now there are two disadvantages:
1. This scale has at least an ordinal level. In your analysis you surely want to calculate some statistical tests to see if there are significant differences. Here you need numerical codes.
You know the mean of "A1", and "A4" is not "A2,5".
2. You want to count the products which are used "often" and "very often".
With numerical codes these are the products with a code >4, e.g. "Produkt1>4".
And in the function "countifop" just countifop(">",4,Produkt1.NAOK)
With your codes which are alphanumerical you have to do it like this:
Produkt1=="A5" OR Produkt1=="A6", as you see in your conditopns for the following questions.
Fortunately string comparison will work, because "A4" is less than "A5", but beware: "A10" is less than "A4".
And you used "Condition builder" instead of "Expression Manger".
In my opinion the condition builder is outdated. Expression Manager is much more flexible.
And you get in trouble if you want to change the structure.
Furthermore there is an error in "Produkt11", The code was changed to "r158q0"
<row>
<qid><![CDATA[616]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[831492]]></sid>
<gid><![CDATA[63]]></gid>
<type><![CDATA[F]]></type>
<title><![CDATA[r158q0]]></title>
Well, enter this in the relevance equation of each group (you see there is the change code; maybe it happened during export)
Group "Produkt 1":
sum(countifop(">","A4",Produkt2_SQ001.NAOK),countifop(">","A4",Produkt3_SQ001.NAOK),countifop(">","A4",Produkt4_SQ001.NAOK),countifop(">","A4",Produkt5_SQ001.NAOK),countifop(">","A4",Produkt6_SQ001.NAOK),countifop(">","A4",Produkt7_SQ001.NAOK),countifop(">","A4",Produkt8_SQ001.NAOK),countifop(">","A4",Produkt9_SQ001.NAOK),countifop(">","A4",Produkt10_SQ001.NAOK),countifop(">","A4",r158q0_SQ001.NAOK),countifop(">","A4",Produkt12_SQ001.NAOK),countifop(">","A4",Produkt13_SQ001.NAOK),countifop(">","A4",Produkt14_SQ001.NAOK),countifop(">","A4",Produkt15_SQ001.NAOK),countifop(">","A4",Produkt16_SQ001.NAOK),countifop(">","A4",Produkt17_SQ001.NAOK),countifop(">","A4",Produkt18_SQ001.NAOK),countifop(">","A4",Produkt19_SQ001.NAOK),countifop(">","A4",Produkt20_SQ001.NAOK)) lt 10
Group "Produkt 2":
sum(countifop(">","A4",Produkt1_SQ001.NAOK),countifop(">","A4",Produkt3_SQ001.NAOK),countifop(">","A4",Produkt4_SQ001.NAOK),countifop(">","A4",Produkt5_SQ001.NAOK),countifop(">","A4",Produkt6_SQ001.NAOK),countifop(">","A4",Produkt7_SQ001.NAOK),countifop(">","A4",Produkt8_SQ001.NAOK),countifop(">","A4",Produkt9_SQ001.NAOK),countifop(">","A4",Produkt10_SQ001.NAOK),countifop(">","A4",r158q0_SQ001.NAOK),countifop(">","A4",Produkt12_SQ001.NAOK),countifop(">","A4",Produkt13_SQ001.NAOK),countifop(">","A4",Produkt14_SQ001.NAOK),countifop(">","A4",Produkt15_SQ001.NAOK),countifop(">","A4",Produkt16_SQ001.NAOK),countifop(">","A4",Produkt17_SQ001.NAOK),countifop(">","A4",Produkt18_SQ001.NAOK),countifop(">","A4",Produkt19_SQ001.NAOK),countifop(">","A4",Produkt20_SQ001.NAOK)) lt 10
You see, there are all Produkte, except the Produkt of that group.
By the way:
Could be shorter by NOT using a question of type array and using shorter question codes (P1,P2,...) and numerical codes.
Next idea: Use a question of type array(number) or multiple numerical input for the price question (and validate).
Will look better.
Joffm
Maybe later I'll send a limited example (less than 20 products)
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.