2 Replies Latest reply: Feb 22, 2016 2:57 PM by Jeff Dunn RSS

    KPI to return the Max value of a Sum

    Jeff Dunn

      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.