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
ExamScore
0-20%
20-40%
40-60%
60-80%
80-100%
10
Range
10
32
58
81
88
20
Count
1
1
1
2
2
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.
