topic Re: average function excluding zero fields in App Development https://community.qlik.com/t5/App-Development/average-function-excluding-zero-fields/m-p/1221049#M23737 <HTML><HEAD></HEAD><BODY><P>From Add-ons Section&nbsp; of chart uncheck show zero values.</P><P>It might help.</P></BODY></HTML> Wed, 09 Nov 2016 10:47:05 GMT shraddha_g 2016-11-09T10:47:05Z average function excluding zero fields https://community.qlik.com/t5/App-Development/average-function-excluding-zero-fields/m-p/1221048#M23736 <HTML><HEAD></HEAD><BODY><P>I want to display an average setup time for machines, however some days some machines don't have a setup, so the setup time is zero for those days. How can I exclude this data?</P></BODY></HTML> Wed, 09 Nov 2016 10:24:42 GMT https://community.qlik.com/t5/App-Development/average-function-excluding-zero-fields/m-p/1221048#M23736 2016-11-09T10:24:42Z Re: average function excluding zero fields https://community.qlik.com/t5/App-Development/average-function-excluding-zero-fields/m-p/1221049#M23737 <HTML><HEAD></HEAD><BODY><P>From Add-ons Section&nbsp; of chart uncheck show zero values.</P><P>It might help.</P></BODY></HTML> Wed, 09 Nov 2016 10:47:05 GMT https://community.qlik.com/t5/App-Development/average-function-excluding-zero-fields/m-p/1221049#M23737 shraddha_g 2016-11-09T10:47:05Z Re: average function excluding zero fields https://community.qlik.com/t5/App-Development/average-function-excluding-zero-fields/m-p/1221050#M23738 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>Avg({&lt;Date = {"=Sum(Setup) &lt;&gt; 0"}&gt;}Setup)</STRONG></P></BODY></HTML> Wed, 09 Nov 2016 10:50:10 GMT https://community.qlik.com/t5/App-Development/average-function-excluding-zero-fields/m-p/1221050#M23738 sunny_talwar 2016-11-09T10:50:10Z