topic Re: get average in QlikView https://community.qlik.com/t5/QlikView/get-average/m-p/1400185#M804352 <HTML><HEAD></HEAD><BODY><P>Forget the aggr. Just use:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Avg(PRICE)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">-Rob<BR /></SPAN></P></BODY></HTML> Thu, 16 Nov 2017 04:14:08 GMT rwunderlich 2017-11-16T04:14:08Z get average https://community.qlik.com/t5/QlikView/get-average/m-p/1400183#M804350 <HTML><HEAD></HEAD><BODY><P>Hello There,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; my concern is about the average of the category price, but base on my expression i got wrong average i don't know why can you </P><P>help me correct me if i'm wrong. Kindly see the attached file.</P><P></P><P>here my expressions:</P><P>Sum(Aggr(Avg(PRICE), [CATEGORY]))</P><P></P><P>Screenshot:</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/183466_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Best Regards,</P><P>Bing</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/get-average/m-p/1400183#M804350 bsbernabe 2020-11-25T16:16:04Z Re: get average https://community.qlik.com/t5/QlikView/get-average/m-p/1400184#M804351 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Not sure I understand. Why don't you use just simple Avg(PRICE)?</P><P></P><P>Cheers,</P><P></P><P>Luis</P></BODY></HTML> Thu, 16 Nov 2017 03:51:05 GMT https://community.qlik.com/t5/QlikView/get-average/m-p/1400184#M804351 luismadriz 2017-11-16T03:51:05Z Re: get average https://community.qlik.com/t5/QlikView/get-average/m-p/1400185#M804352 <HTML><HEAD></HEAD><BODY><P>Forget the aggr. Just use:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Avg(PRICE)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">-Rob<BR /></SPAN></P></BODY></HTML> Thu, 16 Nov 2017 04:14:08 GMT https://community.qlik.com/t5/QlikView/get-average/m-p/1400185#M804352 rwunderlich 2017-11-16T04:14:08Z Re: get average https://community.qlik.com/t5/QlikView/get-average/m-p/1400186#M804353 <HTML><HEAD></HEAD><BODY><P>Like this???</P></BODY></HTML> Thu, 16 Nov 2017 04:15:07 GMT https://community.qlik.com/t5/QlikView/get-average/m-p/1400186#M804353 prma7799 2017-11-16T04:15:07Z Re: get average https://community.qlik.com/t5/QlikView/get-average/m-p/1400187#M804354 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Just wondering to know how did you go,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Cheers</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Luis</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others</P></BODY></HTML> Tue, 21 Nov 2017 07:17:04 GMT https://community.qlik.com/t5/QlikView/get-average/m-p/1400187#M804354 luismadriz 2017-11-21T07:17:04Z