Ranking choice dynamically determined by the options selected in the previous select multiple question

abhishekdas · February 17, 2021, 5:05am

Hi all,

I recently started using kobotoolbox and working great mostly. However, I am not able to formulate one question and I need help for that.
I want to prepare a question in the following way:
A. Why are you buying the product X
 reason 1
 reason 2
 reason 3
 reason 4
 reason 5
 reason 6
 reason 7
 reason 8
 reason 9
 reason 10

B. Rank the reason
reason Rank1 Rank2 Rank3 Rank4 Rank5 Rank6 Rank7 Rank8 Rank9 Rank 10
reason 1
reason 2
reason 3
reason 4
reason 5
reason 6
reason 7
reason 8
reason 9
reason 10

Now I want to make dynamically. In the first phase; consider a person chooses five reasons (let’s say; reason 2, reason 3, reason 6, reason7, and reason 8), which are appropriate for him. Now in the second phase, I want to rank only these reasons not other (i.e. here in our example we will not consider reason 1, reason 4, reason 5, reason9, reason 8, and reason10). Therefore the table will become in the following way:
reason Rank1 Rank2 Rank3 Rank4 Rank5
reason 2
reason 3
reason 6
reason 7
reason 8

This 2nd table will change as per the reason choose in the first table.
thank you

Kal_Lam · February 17, 2021, 5:14am

Welcome to the community @abhishekdas! Maybe this post discussed previously should help you solve your issue:

abhishekdas · February 17, 2021, 5:24am

thank you for your prompt answer. I have already gone through this. but my issue is slightly different from this. here in the second phase rank only the 3 reason/factor out of the reason/factor choosing from the first phase. But I want to rank all the choosing reason. if some one choose 3 reason in the first phase then rank this 3 reason. if some one choose 5 reason in first phase then rank those 5 reason and so on.
thank you

Kal_Lam · February 17, 2021, 6:39am

OK, maybe this workaround should solve your issue:

In the survey tab of your xlsform:

In the choices tab of your xlsform:

Data entry screen as seen in Enketo: (when 3 options are selected)

Data entry screen as seen in Enketo: (when 4 options are selected)

Reference xlsform:

Ranking with Cascading.xls (28.5 KB)

abhishekdas · February 17, 2021, 7:26am

Excellent… this is what I want to do…
thanks a lot.