topic Re: Avg function not giving any value in graph. in App Development https://community.qlik.com/t5/App-Development/Avg-function-not-giving-any-value-in-graph/m-p/1198880#M22642 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Avg(Aggr(Only({&lt;Status = {'*Order*'}, UNITRATE <SPAN style="color: #ff0000;">= {'&gt;0'}</SPAN>&gt;} UNITRATE), ENQNO)) </STRONG></SPAN></P></BODY></HTML> Sat, 15 Oct 2016 21:49:40 GMT sunny_talwar 2016-10-15T21:49:40Z Avg function not giving any value in graph. https://community.qlik.com/t5/App-Development/Avg-function-not-giving-any-value-in-graph/m-p/1198879#M22641 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have below kind of data available for my enquiries, and I am trying to calculate Avg Rate. while computing avg rate, I have to ignore null rate and negative rate from table. Can somebody help me to put correct formulate to compute this.(values are smudged for privacy reason)</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/140735_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>currently I have put below as formula</P><P>Avg(Aggr(Only({&lt;Status = {'*Order*'},UNITRATE&gt;= {0} &gt;} UNITRATE), ENQNO)) AND MY GRAPH SHOWS AS BELOW.</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/140736_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Sat, 15 Oct 2016 11:52:06 GMT https://community.qlik.com/t5/App-Development/Avg-function-not-giving-any-value-in-graph/m-p/1198879#M22641 2016-10-15T11:52:06Z Re: Avg function not giving any value in graph. https://community.qlik.com/t5/App-Development/Avg-function-not-giving-any-value-in-graph/m-p/1198880#M22642 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Avg(Aggr(Only({&lt;Status = {'*Order*'}, UNITRATE <SPAN style="color: #ff0000;">= {'&gt;0'}</SPAN>&gt;} UNITRATE), ENQNO)) </STRONG></SPAN></P></BODY></HTML> Sat, 15 Oct 2016 21:49:40 GMT https://community.qlik.com/t5/App-Development/Avg-function-not-giving-any-value-in-graph/m-p/1198880#M22642 sunny_talwar 2016-10-15T21:49:40Z