Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
JustinDallas
Not applicable

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.

1 Reply
sunny_talwar
Not applicable

Re: Calculate Percentile

So, what exactly are you hoping to get?