topic Survey Values Entry - Qlik Sense in App Development

Survey Values Entry - Qlik Sense

joeybird — Thu, 27 Aug 2015 08:43:00 GMT

Hiya

I have a survey that has been collated. however I have an issue. I have been using the following calculation

SUM({$<[QuestionID] ={"Q2"}>}Answer) / count ( Distinct {$<[QuestionID] ={"Q2"}>} PersonID) * 100

question as three options

1.Yes

2.No

3.Dont Know

However if a person has left a blank for their answer then , N/A (no answer) has been entered for all three responses. Hence I can only currently add up Reponses with a 1 or 0 value

I need to however calculate the percentage for

1.Yes

2.No

3.Dont Know

4.No Response (N/A entry)

any ideas please

Kind Regards

JoeyBird

Re: Survey Values Entry - Qlik Sense

sunny_talwar — Thu, 27 Aug 2015 08:55:11 GMT

Would you be able to provide some sample data with your expected output?

Re: Survey Values Entry - Qlik Sense

joeybird — Thu, 27 Aug 2015 08:59:35 GMT

Hiya

I wish to show a bar graph with percentage of each

1.Yes

2.No

3.Dont Know

4.No Response (N/A entry)

here is example data

Yes	No	Don't Know
1	0	0
N/A	N/A	N/A

Kind Regards

Joey Bird