Survey Values Entry - Qlik Sense

[joeybird]

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

[sunny_talwar]

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

[joeybird]

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