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