topic Re: TOTAL Average is different in QlikView https://community.qlik.com/t5/QlikView/TOTAL-Average-is-different/m-p/409161#M152142 <HTML><HEAD></HEAD><BODY><P>Thanks.</P><P>You're right.</P></BODY></HTML> Fri, 12 Oct 2012 17:43:12 GMT Anonymous 2012-10-12T17:43:12Z TOTAL Average is different https://community.qlik.com/t5/QlikView/TOTAL-Average-is-different/m-p/409158#M152139 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I calculate total average by column in QV.</P><P>Then I export this table in excel and calculate total average by column in excel.</P><P>I get different results.</P><P>Do you know why?</P><P>Please see attached files.</P><P>Thanks,</P></BODY></HTML> Fri, 12 Oct 2012 15:22:06 GMT https://community.qlik.com/t5/QlikView/TOTAL-Average-is-different/m-p/409158#M152139 Anonymous 2012-10-12T15:22:06Z Re: TOTAL Average is different https://community.qlik.com/t5/QlikView/TOTAL-Average-is-different/m-p/409159#M152140 <HTML><HEAD></HEAD><BODY><P>I found why. Some surveyID have 0 as result. QV doesn't show 0.</P><P>How can I show 0?</P></BODY></HTML> Fri, 12 Oct 2012 17:25:06 GMT https://community.qlik.com/t5/QlikView/TOTAL-Average-is-different/m-p/409159#M152140 Anonymous 2012-10-12T17:25:06Z Re: TOTAL Average is different https://community.qlik.com/t5/QlikView/TOTAL-Average-is-different/m-p/409160#M152141 <HTML><HEAD></HEAD><BODY><P>Hi Vladimir,</P><P></P><P>In the Presentation tab of the properties, uncheck the flag "Suppress Zero-Values".</P></BODY></HTML> Fri, 12 Oct 2012 17:38:59 GMT https://community.qlik.com/t5/QlikView/TOTAL-Average-is-different/m-p/409160#M152141 2012-10-12T17:38:59Z Re: TOTAL Average is different https://community.qlik.com/t5/QlikView/TOTAL-Average-is-different/m-p/409161#M152142 <HTML><HEAD></HEAD><BODY><P>Thanks.</P><P>You're right.</P></BODY></HTML> Fri, 12 Oct 2012 17:43:12 GMT https://community.qlik.com/t5/QlikView/TOTAL-Average-is-different/m-p/409161#M152142 Anonymous 2012-10-12T17:43:12Z