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
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.