topic Avg calculation in QlikView https://community.qlik.com/t5/QlikView/Avg-calculation/m-p/500298#M1146115 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can any one help me...</P><P></P><P>i have below table in excel it is showing 6.111 but QV if i use avg(rating) it is showing 4.00. why is this? but 6.111 is correct one...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 241px;"><TBODY><TR><TD class="xl68" height="17" width="84">CallNo</TD><TD class="xl63" style="border-left: medium none;" width="116">CSatRemarks</TD><TD class="xl63" style="border-left: medium none;" width="41">Rating</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">2564882</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Extremely Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">7</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">2312312</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">2323213</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">2123123</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Extremely Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">7</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">23123</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">231231</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">45645645</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Somewhat Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">5</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">4353534</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">123546</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl64" height="17" style="border-top: medium none;"> </TD><TD class="xl65" style="border-left: medium none; border-top: medium none;"> </TD><TD align="right" class="xl69" style="border-left: medium none; border-top: medium none;"><STRONG>6.111</STRONG></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 19 Jul 2013 10:20:41 GMT 2013-07-19T10:20:41Z Avg calculation https://community.qlik.com/t5/QlikView/Avg-calculation/m-p/500298#M1146115 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can any one help me...</P><P></P><P>i have below table in excel it is showing 6.111 but QV if i use avg(rating) it is showing 4.00. why is this? but 6.111 is correct one...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 241px;"><TBODY><TR><TD class="xl68" height="17" width="84">CallNo</TD><TD class="xl63" style="border-left: medium none;" width="116">CSatRemarks</TD><TD class="xl63" style="border-left: medium none;" width="41">Rating</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">2564882</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Extremely Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">7</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">2312312</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">2323213</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">2123123</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Extremely Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">7</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">23123</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">231231</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">45645645</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Somewhat Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">5</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">4353534</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl67" height="17" style="border-top: medium none;">123546</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Satisfied</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl64" height="17" style="border-top: medium none;"> </TD><TD class="xl65" style="border-left: medium none; border-top: medium none;"> </TD><TD align="right" class="xl69" style="border-left: medium none; border-top: medium none;"><STRONG>6.111</STRONG></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 19 Jul 2013 10:20:41 GMT https://community.qlik.com/t5/QlikView/Avg-calculation/m-p/500298#M1146115 2013-07-19T10:20:41Z Re: Avg calculation https://community.qlik.com/t5/QlikView/Avg-calculation/m-p/500299#M1146116 <HTML><HEAD></HEAD><BODY><P>Depends on your data structure in QlikView. Better post an example qvw.</P></BODY></HTML> Fri, 19 Jul 2013 10:25:34 GMT https://community.qlik.com/t5/QlikView/Avg-calculation/m-p/500299#M1146116 luciancotea 2013-07-19T10:25:34Z