Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

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
sunny_talwar

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

joeybird
Creator III
Creator III
Author

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