topic Re: average function in QlikView https://community.qlik.com/t5/QlikView/average-function/m-p/487358#M182034 <HTML><HEAD></HEAD><BODY><P>=avg( if(age_of_servers &gt;0, age_of_servers))</P><P></P><P>or</P><P></P><P>=avg({&lt;age_of_servers = {"&gt;0"}&gt;} age_of_servers)</P></BODY></HTML> Mon, 25 Nov 2013 15:00:12 GMT swuehl 2013-11-25T15:00:12Z average function https://community.qlik.com/t5/QlikView/average-function/m-p/487357#M182033 <HTML><HEAD></HEAD><BODY><P>I have to find the average age of servers but the problem is some of the servers have negative numbers. Is there a way to get the averages only when the age_of_servers &gt; 0??</P></BODY></HTML> Mon, 25 Nov 2013 14:58:33 GMT https://community.qlik.com/t5/QlikView/average-function/m-p/487357#M182033 2013-11-25T14:58:33Z Re: average function https://community.qlik.com/t5/QlikView/average-function/m-p/487358#M182034 <HTML><HEAD></HEAD><BODY><P>=avg( if(age_of_servers &gt;0, age_of_servers))</P><P></P><P>or</P><P></P><P>=avg({&lt;age_of_servers = {"&gt;0"}&gt;} age_of_servers)</P></BODY></HTML> Mon, 25 Nov 2013 15:00:12 GMT https://community.qlik.com/t5/QlikView/average-function/m-p/487358#M182034 swuehl 2013-11-25T15:00:12Z