0 Replies Latest reply: Mar 2, 2017 11:58 AM by Michael Andrews RSS

    Fractiles within a range

    Michael Andrews

      Maybe I'm misunderstanding the fractile function, but it shows everything below what you set the decimal at correct? I.e. if i say Fractile(ExamScore, .75) it gives me the count of all exams below the 75% threshold?

       

      What I'm trying to do is show the fractiles of scores who scored in quintiles.

       

      I.e. I want to show the count of scores that were in the 0-25% range, the count of scores that were in the 25-50% range, etc.

       

      Is there a way to do this in qlik?

       

      Some sample data would look like this

       

        

      ExamScore0-20%20-40%40-60%60-80%80-100%
      10Range1032588188
      20Count11122
      50
      60
      80
      90
      90
      85

       

      Basically. I find the min and max scores, and then cut that into 5ths. From there, I'm showing a count of all items that scored in that range.