topic Re: Lookup in aggr in QlikView https://community.qlik.com/t5/QlikView/Lookup-in-aggr/m-p/1140878#M373846 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>FirstSortedValue(game, -Aggr(Sum(Score), game, player))</STRONG></P><P></P><P>UPDATE: May be you need date in there as well:</P><P></P><P><STRONG style="font-size: 13.3333px;">FirstSortedValue(game, -Aggr(Sum(Score), game, player, <SPAN style="color: #ff0000;">date</SPAN>))</STRONG></P></BODY></HTML> Fri, 19 Aug 2016 13:35:24 GMT sunny_talwar 2016-08-19T13:35:24Z Lookup in aggr https://community.qlik.com/t5/QlikView/Lookup-in-aggr/m-p/1140877#M373845 <HTML><HEAD></HEAD><BODY><P>I'm having a hard time filtering out a result in a subdataset. Right about now I'm working with a gaming company and would need to filter out the game with the best score in a report. Consider this example:</P><P></P><P><STRONG>PROBLEM</STRONG></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135015_Capture.PNG" style="height: 223px; width: 620px;" /></P><P></P><P><STRONG>QUESTION</STRONG></P><P>How do we write the formula for column "best game"?</P><P></P><P>Best Regards</P></BODY></HTML> Fri, 19 Aug 2016 13:08:04 GMT https://community.qlik.com/t5/QlikView/Lookup-in-aggr/m-p/1140877#M373845 2016-08-19T13:08:04Z Re: Lookup in aggr https://community.qlik.com/t5/QlikView/Lookup-in-aggr/m-p/1140878#M373846 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>FirstSortedValue(game, -Aggr(Sum(Score), game, player))</STRONG></P><P></P><P>UPDATE: May be you need date in there as well:</P><P></P><P><STRONG style="font-size: 13.3333px;">FirstSortedValue(game, -Aggr(Sum(Score), game, player, <SPAN style="color: #ff0000;">date</SPAN>))</STRONG></P></BODY></HTML> Fri, 19 Aug 2016 13:35:24 GMT https://community.qlik.com/t5/QlikView/Lookup-in-aggr/m-p/1140878#M373846 sunny_talwar 2016-08-19T13:35:24Z Re: Lookup in aggr https://community.qlik.com/t5/QlikView/Lookup-in-aggr/m-p/1140879#M373847 <HTML><HEAD></HEAD><BODY><P>Have you tried: rank(sum(score)) within such a table-chart?</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 19 Aug 2016 13:36:01 GMT https://community.qlik.com/t5/QlikView/Lookup-in-aggr/m-p/1140879#M373847 marcus_sommer 2016-08-19T13:36:01Z Re: Lookup in aggr https://community.qlik.com/t5/QlikView/Lookup-in-aggr/m-p/1140880#M373848 <HTML><HEAD></HEAD><BODY><P>I was trying around with both aggr and FirstSorted but manage to fail. Thanks a lot guys, it was as simple as that <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 19 Aug 2016 13:56:56 GMT https://community.qlik.com/t5/QlikView/Lookup-in-aggr/m-p/1140880#M373848 2016-08-19T13:56:56Z