topic KPI to return the Max value of a Sum in App Development https://community.qlik.com/t5/App-Development/KPI-to-return-the-Max-value-of-a-Sum/m-p/1087424#M18137 <HTML><HEAD></HEAD><BODY><P>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:</P><P></P><P>PLAYER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; POINTS&nbsp;&nbsp;&nbsp;&nbsp; YEAR</P><P>Jeff&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015</P><P>Matt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015</P><P>Jeff&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">The KPI box should return "14" for 2015 because Jeff scored 5 + 9. </SPAN></P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">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!&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">The app and data are attached if that is helpful.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Mon, 22 Feb 2016 19:39:30 GMT 2016-02-22T19:39:30Z KPI to return the Max value of a Sum https://community.qlik.com/t5/App-Development/KPI-to-return-the-Max-value-of-a-Sum/m-p/1087424#M18137 <HTML><HEAD></HEAD><BODY><P>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:</P><P></P><P>PLAYER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; POINTS&nbsp;&nbsp;&nbsp;&nbsp; YEAR</P><P>Jeff&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015</P><P>Matt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015</P><P>Jeff&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2015</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">The KPI box should return "14" for 2015 because Jeff scored 5 + 9. </SPAN></P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">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!&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">The app and data are attached if that is helpful.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Mon, 22 Feb 2016 19:39:30 GMT https://community.qlik.com/t5/App-Development/KPI-to-return-the-Max-value-of-a-Sum/m-p/1087424#M18137 2016-02-22T19:39:30Z Re: KPI to return the Max value of a Sum https://community.qlik.com/t5/App-Development/KPI-to-return-the-Max-value-of-a-Sum/m-p/1087425#M18138 <HTML><HEAD></HEAD><BODY><P>maybe</P><P></P><P><EM>max(aggr(sum(POINTS), PLAYER))</EM></P></BODY></HTML> Mon, 22 Feb 2016 19:53:00 GMT https://community.qlik.com/t5/App-Development/KPI-to-return-the-Max-value-of-a-Sum/m-p/1087425#M18138 maxgro 2016-02-22T19:53:00Z Re: KPI to return the Max value of a Sum https://community.qlik.com/t5/App-Development/KPI-to-return-the-Max-value-of-a-Sum/m-p/1087426#M18139 <HTML><HEAD></HEAD><BODY><P>That was an easy fix!! Thanks Massimo! Sorry if it was a dumb question. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 22 Feb 2016 19:57:15 GMT https://community.qlik.com/t5/App-Development/KPI-to-return-the-Max-value-of-a-Sum/m-p/1087426#M18139 2016-02-22T19:57:15Z