topic Re: Re: How to include Zero value on an AVG() Function? in QlikView https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552699#M206461 <HTML><HEAD></HEAD><BODY><P>This one doesnt work, shows me the same rasult always, look i let you what i wantin an excel, hope this helps.</P></BODY></HTML> Thu, 31 Oct 2013 16:21:33 GMT 2013-10-31T16:21:33Z How to include Zero value on an AVG() Function? https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552697#M206459 <HTML><HEAD></HEAD><BODY><P>Ive got this on a Pivot table as Expression :</P><P></P><P>Avg(Aggr(Sum( costo_maximo),Semana,MP)) </P><P></P><P>But the Avg only shows the result of the columns with a value.</P><P></P><P>Any suggestion?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 30 Oct 2013 23:20:33 GMT https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552697#M206459 2013-10-30T23:20:33Z Re: How to include Zero value on an AVG() Function? https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552698#M206460 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Instead of that expression try this</P><P></P><P>=Sum(Aggr(Sum( costo_maximo),Semana,MP)) / Sum(Aggr(1, Semana,MP)) </P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 31 Oct 2013 01:28:15 GMT https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552698#M206460 jagan 2013-10-31T01:28:15Z Re: Re: How to include Zero value on an AVG() Function? https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552699#M206461 <HTML><HEAD></HEAD><BODY><P>This one doesnt work, shows me the same rasult always, look i let you what i wantin an excel, hope this helps.</P></BODY></HTML> Thu, 31 Oct 2013 16:21:33 GMT https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552699#M206461 2013-10-31T16:21:33Z Re: How to include Zero value on an AVG() Function? https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552700#M206462 <HTML><HEAD></HEAD><BODY><P>Try deselecting option 'Suppress zero values' on presentation tab.</P></BODY></HTML> Thu, 31 Oct 2013 16:49:38 GMT https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552700#M206462 swuehl 2013-10-31T16:49:38Z Re: How to include Zero value on an AVG() Function? https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552701#M206463 <HTML><HEAD></HEAD><BODY><P>This one was always deselected <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 31 Oct 2013 16:52:37 GMT https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552701#M206463 2013-10-31T16:52:37Z Re: Re: How to include Zero value on an AVG() Function? https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552702#M206464 <HTML><HEAD></HEAD><BODY><P>Then I think you need to post a sample file that demonstrate your issue.</P><P></P><P>I can't reproduce it with the option deselected.</P></BODY></HTML> Thu, 31 Oct 2013 17:25:50 GMT https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552702#M206464 swuehl 2013-10-31T17:25:50Z Re: How to include Zero value on an AVG() Function? https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552703#M206465 <HTML><HEAD></HEAD><BODY><P>Thanks for everything, with your idea of the suprees i just get noticed, those ones are no "0",otherwise thery are missing values!</P></BODY></HTML> Thu, 31 Oct 2013 18:11:20 GMT https://community.qlik.com/t5/QlikView/How-to-include-Zero-value-on-an-AVG-Function/m-p/552703#M206465 2013-10-31T18:11:20Z