How to sum 4 greatest values per row

[JKoczeniak]

I need to sum the best three weeks per participant of an event I am running.  Essentially people need to compete in at least 4 weeks but they could compete in as many as 6.  Its been a while since I have used Qlik and am a bit rusty 🙂  

Logically it would look something like this

If the count of weeks is greater than 4 then sum the greatest 4 values per player.

Data is as follows

Player name    Week   Score

Player 1                 1          50

Player 2                 1          52

Player 1                2           45

Player 2                2           60

etc....

[vishsaggi]

Can you share some more data with example output you are looking for?