topic Re: Max and Avg in QlikView https://community.qlik.com/t5/QlikView/Max-and-Avg/m-p/1390447#M422813 <HTML><HEAD></HEAD><BODY><P>Sorry My bad its 1.5 .</P><P>Thanks for the reply</P></BODY></HTML> Fri, 11 Aug 2017 13:38:54 GMT anushree1 2017-08-11T13:38:54Z Max and Avg https://community.qlik.com/t5/QlikView/Max-and-Avg/m-p/1390445#M422811 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could anyone please let me know how we could perform avg and max equivalent to excel in Qlikview</P><P>Ex:avg(1,2)- Must return 4,</P><P>Similarly Max(5,10) must return 10</P><P></P><P>As of my understanding Max and Avg works on the named column and returns the respective avg or max value .</P><P>But, incase i would need a comparison to be made and have a result produced based on the two values as quoted in the example.</P><P>How could that be done.</P></BODY></HTML> Fri, 11 Aug 2017 13:28:37 GMT https://community.qlik.com/t5/QlikView/Max-and-Avg/m-p/1390445#M422811 anushree1 2017-08-11T13:28:37Z Re: Max and Avg https://community.qlik.com/t5/QlikView/Max-and-Avg/m-p/1390446#M422812 <HTML><HEAD></HEAD><BODY><P>You can use RangeMax() and RangeAvg()</P><P></P><P>=RangeAvg(1, 2) = 1.5 (not sure how you got 4)?</P><P>=RangeMax(5, 10) = 10</P></BODY></HTML> Fri, 11 Aug 2017 13:35:09 GMT https://community.qlik.com/t5/QlikView/Max-and-Avg/m-p/1390446#M422812 sunny_talwar 2017-08-11T13:35:09Z Re: Max and Avg https://community.qlik.com/t5/QlikView/Max-and-Avg/m-p/1390447#M422813 <HTML><HEAD></HEAD><BODY><P>Sorry My bad its 1.5 .</P><P>Thanks for the reply</P></BODY></HTML> Fri, 11 Aug 2017 13:38:54 GMT https://community.qlik.com/t5/QlikView/Max-and-Avg/m-p/1390447#M422813 anushree1 2017-08-11T13:38:54Z