Count selected options

[chauvoice2020]

Hello everyone,
I need help counting all selected options in a multiple select question. How do I do about it eg What are the available FP methods and commodities in stock?
1 Injectables
2 Implants
3 Pills
4 Condoms
5 Emergency Contraceptives
6 IUDs
99 Other (specify)
Thanks in advance

[yanokwa]

Use count-selected(${question_name}) to count the number of selected options.

[chauvoice2020]

Thanks - How about those that are not selected?

[yanokwa]

Try the suggestions below..

Counting the number of all options in a select_one / select_multiple variable

Actually, there is a 'trick'... . If you randomize the choices the XForm will turn them into a nodeset, which you can then use the XPath count() function to count how many there are. Have a play with this form in https://opendatakit.org/xlsform/ count-choices.xls (19.5 KB) [Update] You can also trigger turning the choices to a nodeset with a simple choice_filter, which avoids randomizing your choices... A simple no-op filter like true() will suffice count-choices2.xls (20 KB) [this tr…

Counting the number of all options in a select_one / select_multiple variable

Here's one solution that has worked for me. I have a calculate field with this sort of expression in the calculate field: count(instance('list_product')/root/item[string-length(name)>0]) Where "list_product" is the name of the list itself, and the "string-length(name)>0" just ensures every list item that has a length larger than 0 gets counted so basically everything.

[chauvoice2020]

Thanks but I need to know the number of options not selected. The information shared seems not applicable to this case?

[Hussein_Lightwalla]

What about a combination of 'count(instance('list_product')/root/item[string-length(name)>0])' and 'count-selected(${question_name}' I.e the first minus the second?

[Hussein_Lightwalla]

@chauvoice2020 Here's an example XLSForm which shows how you can do this - it also makes use of the trick showed earlier by @Xiphware of turning a select into a nodeset by using the choice-filter attribute. Hope this helps.
test_count_not_selected.xlsx (7.4 KB)

[Mwaka]

you could try to subtract count-selected(${question_name} from the number of available multiple options