How to calculate socio economic classification and auto terminate

[rockyjunior24gh]

Hello @Kal_Lam,

Please I’m trying to calculate the sclass based on the criteria below, but seems not working for me. Kindly find attached the excel file for your reference. I’m expecting the A or E to be terminated any time the calculation fall on those. Thank you.

SOCIO ECONOMIC GROUP TOTAL SCORE criteria

     A                       = 80 +         TERMINATE
     B                       = 69 - 79      Continue 
     C1                      = 56 - 69      Continue 
     C2                      = 35 - 55      Continue 
     D                       = 16 - 34      Continue 
     E                       = <16          TERMINATE 

Regards,
Ernest.

Sclass.xlsx (17.1 KB)

[rockyjunior24gh]

Please help me resolve this, It’s urgent. Thank you.

[rockyjunior24gh]

Hello @wroos,

Please I need your urgent help on this socio economic classification which I’m unable to work it out.

Kindly find below the criteria. I want A & E calculation to be terminated, but it’s not working. Please look into the attached excel file and see if something can be done for me. Thank you.

 **A**                       = 80 +         **TERMINATE**

 B                       = 69 - 79      Continue

 C1                      = 56 - 69      Continue

 C2                      = 35 - 55      Continue

 D                       = 16 - 34      Continue

 **E**                       = <16          **TERMINATE**

Sclass.xlsx (17.1 KB)

[Kal_Lam]

@rockyjunior24gh, could you please share the specific section of the XLSForm that is causing the issue? This will greatly assist the community in understanding your query and responding more effectively.

[rockyjunior24gh]

Hi @Kal_Lam, thanks for your feedback.

Please find attached the Kobo script and well as the questionnaire in excel format. Please work on it and share with me back.

questionnaire.xlsx (32.0 KB)

afNkYe95zAvyMQC3z9ZEvZ.xlsx (26.4 KB)

Best regards,

Ernest.

[enuguwestngcares]

Pls help me, I want to learn how to collect the data, am new here pls, teach me

[rockyjunior24gh]

Hello @Kal_Lam, please any update on the files shared with you. Your immediate response would be highly appreciated.

Thanks and regards,

Ernest.

[raquelchaicoj]

Hello all, I tested it, and it seems it works now:

What I changed was the following:

calculate- code-Calculation:

if(${sclassscores}>=80 or ${sclassscores}<16, “TERMINATE”, “CONTINUE”)

select_one Terminate-Terminate_Thank_you1-Unfortunately, this Respondent does not meet the survey criteria, click next and close interview-relevant: ${code} = “TERMINATE”

I am attaching the XLS form, the line changed was 73 and 172.

Hope it works!

afNkYe95zAvyMQC3z9ZEvZ.xlsx (26.4 KB)

[Xiphware]

@rockyjunior24gh

I’m expecting the A or E to be terminated any time the calculation fall on those

To be clear, you cannot ‘terminate’ a form half-way; rather, you instead make all subsequent questions non-relevant so they become not shown. And the easiest way to do this is put them all inside a group, and add a relevant condition on that group.

Here’s a simple example:

SimpleForm.xlsx (18.4 KB)

If you disagree - or, equivalently, the respondent doesn’t meet your required criteria - then the form basically ‘terminates’ because everything else subsequent in the form (inside the group) is now non-relevant.

Whereas if you agree, then the form basically ‘continues’ because the rest of the questions are now relevant and therefore displayed.

In your example, the relevant criteria (ie when not to terminate) on such a group would be something like:
${sclassscores}<80 and ${sclassscores}>=16

[rockyjunior24gh]

This is great! Thank you very much @raquelchaicoj.

[rockyjunior24gh]

@Xiphware, This is very well noted, thank you so much. Will comply accordingly. Cheers.