Page 1 of 1

Counting number of questions answered

Posted: November 14th, 2017, 12:48 pm
by bidhu
Hi,

I want to see how many questions are asked by investigators in each section of a questionnaire. For that I need to count the number of questions with not applicable values. I tried counting it using countNonSpecial function. But, it is not providing me the right value. Can anyone suggest if there is a simpler way of counting the number of questions that has been answered in one record?

Re: Counting number of questions answered

Posted: November 15th, 2017, 2:36 pm
by htuser
Hi Bidhu,
It's possible by using the new sqlquery function and paradata. Since paradata isn't yet supported in help and 7.1 version is in alpha. You've to wait.
Maybe someone have another way and can help us.
Best regards,

Re: Counting number of questions answered

Posted: November 15th, 2017, 6:15 pm
by josh
I would just create a counter variable that I initialize to zero at the start of the record and increment in each postproc when the question is answered. A lot of copy and pasting but it would work.

Re: Counting number of questions answered

Posted: November 15th, 2017, 11:14 pm
by bidhu
Thank you, Josh. I thought of the second way. But, I was looking for a simpler solution. Also, I wanted to implement it as part of the Monitoring program to monitor progress in survey using the HTML program. As of now, I am using the countvalid function and doing some adjustment to it for each section.