Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

Survey Values Entry - Qlik Sense

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

2 Replies
MVP
MVP

Re: Survey Values Entry - Qlik Sense

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

joeybird
Contributor II

Re: Survey Values Entry - Qlik Sense

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

YesNoDon't Know
100
N/AN/AN/A

Kind Regards

Joey Bird