topic Re: Get Max average form a data set in QlikView https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492930#M1129509 <HTML><HEAD></HEAD><BODY><P>try this</P><P>if(max((subject1+subject2+subject3)/3)&lt;&gt;0,Student)</P></BODY></HTML> Tue, 26 Nov 2013 11:36:33 GMT 2013-11-26T11:36:33Z Get Max average form a data set https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492926#M1129499 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a data set like below,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUBJECT 1&nbsp;&nbsp;&nbsp;&nbsp; SUBJECT 2&nbsp;&nbsp;&nbsp;&nbsp; SUBJECT 3</P><P>STUDENT A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 58&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 75</P><P>STUDENT B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 36&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 89&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 72</P><P>STUDENT C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P></P><P></P><P></P><P>I want to get the STUDENT who has the highest AVERAGE in all subjects,</P><P></P><P>Pls help me.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 26 Nov 2013 11:24:16 GMT https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492926#M1129499 anuradhaa 2013-11-26T11:24:16Z Re: Get Max average form a data set https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492927#M1129506 <HTML><HEAD></HEAD><BODY><P>max(aggr(avg(Score),Student))</P></BODY></HTML> Tue, 26 Nov 2013 11:25:52 GMT https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492927#M1129506 Anonymous 2013-11-26T11:25:52Z Re: Get Max average form a data set https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492928#M1129507 <HTML><HEAD></HEAD><BODY><P>May be like this?</P><P></P><P>=FirstSortedvalue( Student, -Aggr(Avg(Score), Student))</P></BODY></HTML> Tue, 26 Nov 2013 11:33:48 GMT https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492928#M1129507 tresB 2013-11-26T11:33:48Z Re: Get Max average form a data set https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492929#M1129508 <HTML><HEAD></HEAD><BODY><P>Check enclosed file...</P></BODY></HTML> Tue, 26 Nov 2013 11:33:51 GMT https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492929#M1129508 MK_QSL 2013-11-26T11:33:51Z Re: Get Max average form a data set https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492930#M1129509 <HTML><HEAD></HEAD><BODY><P>try this</P><P>if(max((subject1+subject2+subject3)/3)&lt;&gt;0,Student)</P></BODY></HTML> Tue, 26 Nov 2013 11:36:33 GMT https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492930#M1129509 2013-11-26T11:36:33Z Re: Get Max average form a data set https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492931#M1129510 <HTML><HEAD></HEAD><BODY><P>Thanks All</P></BODY></HTML> Tue, 26 Nov 2013 11:37:02 GMT https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492931#M1129510 anuradhaa 2013-11-26T11:37:02Z Re: Get Max average form a data set https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492932#M1129511 <HTML><HEAD></HEAD><BODY><P>How to get the lowset one, i try with lastsortedvalue but doesn't work.</P><P></P><P>thanks</P></BODY></HTML> Tue, 26 Nov 2013 11:40:34 GMT https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492932#M1129511 anuradhaa 2013-11-26T11:40:34Z Re: Get Max average form a data set https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492933#M1129512 <HTML><HEAD></HEAD><BODY><P>Got it, just remove the - mark infront of aggr</P></BODY></HTML> Tue, 26 Nov 2013 11:44:40 GMT https://community.qlik.com/t5/QlikView/Get-Max-average-form-a-data-set/m-p/492933#M1129512 anuradhaa 2013-11-26T11:44:40Z