Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III
‎2017-06-02 12:10 PM

Calculate Percentile

Hello Everyone,

I've got a demo chart where we have Players, and we have a list of their PlayerScores in a game.  What I would like, is that I can have something that says: "Player Two scored in the top 20% of all players".  I've googled till I was blue in the face, and have yet to find anything that matches what I'm trying to do.  I've floundered with the SUM(Score)/(SUM(TOTAL Score) and that only gives me "the percentage of the total score that this players score is responsible for".

I've attached a demo file of some dummy data, but this is what it looks like thus far.

Percentile.PNG

Any help is greatly appreciated.

TestAggregate.qvf
544 Views
1 Reply
sunny_talwar
MVP
MVP
‎2017-06-02 12:19 PM

So, what exactly are you hoping to get?

302 Views
0 Likes