Hello developers,
The title may seem a bit confusing so I will try to explain in simple terms. Let´s say I have player names and their scores accordingly, so, two dimensions (player, score points). If I display it in a table, I will see something like this:
| Player |
Score |
| Total |
100 |
| Marcus |
20 |
| Albert |
33 |
| Sam |
8 |
| Jhon |
4 |
| Benedict |
22 |
| Kara |
13 |
I would like to order this table by the player that has most scores first when I calculate what players make the 80% of the score. So basically, I want the scores to be adding in order, until i reach the 80% of the total score of 100 (so that would be 80 score in total) and prove that this 3 players (for example) are the ones who made the 80% of the score.
I think I have to use aggr with rank, and sum(total) or something like that but I don´t know how to start in QLIKSENSE.
Any help is appreciated,
Thank you, Diego.
