topic Avg - issue in QlikView https://community.qlik.com/t5/QlikView/Avg-issue/m-p/920342#M983489 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need to show avg salary value inplace of 0, for example </P><P></P><P>I have title X itz avg salary is 1500, 1500 value should display in first row as well for the Name Kim, but</P><P>it is showing once.</P><P></P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 366px;"><TBODY><TR><TD class="xl65" height="17" width="98">Title</TD><TD class="xl66" style="border-left: none;" width="98">Name</TD><TD class="xl66" style="border-left: none;" width="72">Salary</TD><TD class="xl67" style="border-left: none;" width="98">Avg Salary</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">X</TD><TD class="xl63" style="border-top: none; border-left: none;">Kim</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">2000</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">X</TD><TD class="xl63" style="border-top: none; border-left: none;">Jane</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">1000</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">1500</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">Y</TD><TD class="xl63" style="border-top: none; border-left: none;">Kelly</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">4000</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">Y</TD><TD class="xl63" style="border-top: none; border-left: none;">Sally</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">3000</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">3500</TD></TR><TR><TD class="xl72" height="18" style="border-top: none;">Z</TD><TD class="xl73" style="border-top: none; border-left: none;">Kiran</TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">5000</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">5000</TD></TR></TBODY></TABLE><P></P><P>Expected</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 366px;"><TBODY><TR><TD class="xl65" height="17" width="98">Title</TD><TD class="xl66" style="border-left: none;" width="98">Name</TD><TD class="xl66" style="border-left: none;" width="72">Salary</TD><TD class="xl67" style="border-left: none;" width="98">Avg Salary</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">X</TD><TD class="xl63" style="border-top: none; border-left: none;">Kim</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;"><P></P><P>2000</P></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1500</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">X</TD><TD class="xl63" style="border-top: none; border-left: none;">Jane</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">1000</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">1500</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">Y</TD><TD class="xl63" style="border-top: none; border-left: none;">Kelly</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">4000</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">3500</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">Y</TD><TD class="xl63" style="border-top: none; border-left: none;">Sally</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">3000</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">3500</TD></TR><TR><TD class="xl72" height="18" style="border-top: none;">Z</TD><TD class="xl73" style="border-top: none; border-left: none;">Kiran</TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">5000</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">5000</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT 2020-11-20T18:02:30Z Avg - issue https://community.qlik.com/t5/QlikView/Avg-issue/m-p/920342#M983489 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need to show avg salary value inplace of 0, for example </P><P></P><P>I have title X itz avg salary is 1500, 1500 value should display in first row as well for the Name Kim, but</P><P>it is showing once.</P><P></P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 366px;"><TBODY><TR><TD class="xl65" height="17" width="98">Title</TD><TD class="xl66" style="border-left: none;" width="98">Name</TD><TD class="xl66" style="border-left: none;" width="72">Salary</TD><TD class="xl67" style="border-left: none;" width="98">Avg Salary</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">X</TD><TD class="xl63" style="border-top: none; border-left: none;">Kim</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">2000</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">X</TD><TD class="xl63" style="border-top: none; border-left: none;">Jane</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">1000</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">1500</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">Y</TD><TD class="xl63" style="border-top: none; border-left: none;">Kelly</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">4000</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">Y</TD><TD class="xl63" style="border-top: none; border-left: none;">Sally</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">3000</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">3500</TD></TR><TR><TD class="xl72" height="18" style="border-top: none;">Z</TD><TD class="xl73" style="border-top: none; border-left: none;">Kiran</TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">5000</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">5000</TD></TR></TBODY></TABLE><P></P><P>Expected</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 366px;"><TBODY><TR><TD class="xl65" height="17" width="98">Title</TD><TD class="xl66" style="border-left: none;" width="98">Name</TD><TD class="xl66" style="border-left: none;" width="72">Salary</TD><TD class="xl67" style="border-left: none;" width="98">Avg Salary</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">X</TD><TD class="xl63" style="border-top: none; border-left: none;">Kim</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;"><P></P><P>2000</P></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1500</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">X</TD><TD class="xl63" style="border-top: none; border-left: none;">Jane</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">1000</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">1500</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">Y</TD><TD class="xl63" style="border-top: none; border-left: none;">Kelly</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">4000</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">3500</TD></TR><TR><TD class="xl70" height="17" style="border-top: none;">Y</TD><TD class="xl63" style="border-top: none; border-left: none;">Sally</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">3000</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">3500</TD></TR><TR><TD class="xl72" height="18" style="border-top: none;">Z</TD><TD class="xl73" style="border-top: none; border-left: none;">Kiran</TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">5000</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">5000</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Avg-issue/m-p/920342#M983489 2020-11-20T18:02:30Z Re: Avg - issue https://community.qlik.com/t5/QlikView/Avg-issue/m-p/920343#M983490 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>= avg(aggr(sum(Salary), Title))</P></BODY></HTML> Wed, 12 Aug 2015 09:16:58 GMT https://community.qlik.com/t5/QlikView/Avg-issue/m-p/920343#M983490 oknotsen 2015-08-12T09:16:58Z Re: Avg - issue https://community.qlik.com/t5/QlikView/Avg-issue/m-p/920344#M983491 <HTML><HEAD></HEAD><BODY><P>avg(TOTAL &lt;Title&gt; Salary)</P></BODY></HTML> Wed, 12 Aug 2015 09:21:12 GMT https://community.qlik.com/t5/QlikView/Avg-issue/m-p/920344#M983491 maxgro 2015-08-12T09:21:12Z Re: Avg - issue https://community.qlik.com/t5/QlikView/Avg-issue/m-p/920345#M983492 <HTML><HEAD></HEAD><BODY><P>Thank you massimo it worked</P></BODY></HTML> Wed, 12 Aug 2015 09:24:15 GMT https://community.qlik.com/t5/QlikView/Avg-issue/m-p/920345#M983492 2015-08-12T09:24:15Z