2 Replies Latest reply: Aug 27, 2015 5:00 AM by Joanna Seldon RSS

    Survey Values Entry  - Qlik Sense

    Joanna Seldon

      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