I feel like I am close to a fix here, but I can't seem to get the syntax right... I have a spreadsheet with the following columns: Goals, Assists, Points, Year (there's actually more to it, but this is the general gist). I want to create a KPI box in Qlik Sense that returns the highest sum of all goals, assists, and points (seperately) for a given year (or all years if not filtered). In other words, if this is the data:
PLAYER POINTS YEAR
Jeff 5 2015
Matt 10 2015
Jeff 9 2015
The KPI box should return "14" for 2015 because Jeff scored 5 + 9.
So, somehow, I know I need to incorporate MAX and SUM together, but can't figure out the way to do it. Any help would be appreciated!