Split ODK Multiple Choice Answers for Easy Analysis in Qlik Sense
ODK Multiple Choice Questions can be so annoying to analyse and post-process! But this video shows a very easy method of having Qlik Sense split out the multiple choice answers into single values for easy analysis.
Here's the code for the Qlik Script Editor so you can easily copy and paste it into your own Qlik Sense script editor:
Load
_uuid,
Subfield(toilet,' ') as ToiletType
From [lib://Desktop/Multiple Choice Test Demo.xlsx]
(ooxml, embedded labels, table is Sheet1);