topic Re: Finding average getting two different results in QlikView https://community.qlik.com/t5/QlikView/Finding-average-getting-two-different-results/m-p/430321#M160421 <HTML><HEAD></HEAD><BODY><P>Hello Fernando,</P><P></P><P>Yes, your exactly correct, beacuse of Zero only it was happend.</P><P></P><P>Thanks a lot</P><P></P><P>Regards</P><P></P><P>Ammu</P></BODY></HTML> Fri, 18 Jan 2013 11:27:35 GMT 2013-01-18T11:27:35Z Finding average getting two different results https://community.qlik.com/t5/QlikView/Finding-average-getting-two-different-results/m-p/430319#M160419 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>Its dificult to understand the find the average of amount. I am getting two different strange results in qlikview to find the avg (Freight in Euro) it gives 1177.50 but in excel it gives 1597.90.</P><P></P><P>It really strange to understand it, is any one faced such error. I have encircled the error in the attached image.</P><P></P><P>Please update me....</P><P></P><P>Regards</P><P></P><P>Ammu</P></BODY></HTML> Thu, 17 Jan 2013 12:50:52 GMT https://community.qlik.com/t5/QlikView/Finding-average-getting-two-different-results/m-p/430319#M160419 2013-01-17T12:50:52Z Re: Finding average getting two different results https://community.qlik.com/t5/QlikView/Finding-average-getting-two-different-results/m-p/430320#M160420 <HTML><HEAD></HEAD><BODY><P>Check the attached qvw.</P><P></P><P>My data model has 4 values: 0, 1, 2 and 3, and QlikView calculates the average considering the zero value. </P><P></P><P>If your chart has the 'suppress zero values' option, then it will be ommitted from the chart but still considered in the average.</P><P></P><P>When you export to excel, the zero value is not included, so the average will return a different value.</P><P></P><P></P><P></P><P></P><P>Hope this helps</P><P>Fernando </P></BODY></HTML> Thu, 17 Jan 2013 18:00:27 GMT https://community.qlik.com/t5/QlikView/Finding-average-getting-two-different-results/m-p/430320#M160420 fosuzuki 2013-01-17T18:00:27Z Re: Finding average getting two different results https://community.qlik.com/t5/QlikView/Finding-average-getting-two-different-results/m-p/430321#M160421 <HTML><HEAD></HEAD><BODY><P>Hello Fernando,</P><P></P><P>Yes, your exactly correct, beacuse of Zero only it was happend.</P><P></P><P>Thanks a lot</P><P></P><P>Regards</P><P></P><P>Ammu</P></BODY></HTML> Fri, 18 Jan 2013 11:27:35 GMT https://community.qlik.com/t5/QlikView/Finding-average-getting-two-different-results/m-p/430321#M160421 2013-01-18T11:27:35Z