Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

michael_andrews
New Contributor III

Fractiles within a range

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.