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!
The app and data are attached if that is helpful.
