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.