topic Re: Excluding Outliers from Avg Calculations at the dimension level in App Development https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414838#M33385 <HTML><HEAD></HEAD><BODY><P>‌yes. I just want to exclude the upper outliers.</P></BODY></HTML> Mon, 20 Nov 2017 13:38:14 GMT Anonymous 2017-11-20T13:38:14Z Excluding Outliers from Avg Calculations at the dimension level https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414836#M33383 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">All,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I need to plot monthly average trend. Each month behaves differently hence the need to exclude outliers at the month level. This calculation needs to be dynamic if I need to look at the trend by a certain category (the outliers need to be recalculated at the category level by each month)</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I have attached a sample QVF.</P></BODY></HTML> Fri, 17 Nov 2017 14:21:14 GMT https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414836#M33383 Anonymous 2017-11-17T14:21:14Z Re: Excluding Outliers from Avg Calculations at the dimension level https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414837#M33384 <HTML><HEAD></HEAD><BODY><P>Is the outliers in one direction only or do we have outliers in both directions?</P></BODY></HTML> Mon, 20 Nov 2017 12:59:10 GMT https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414837#M33384 sunny_talwar 2017-11-20T12:59:10Z Re: Excluding Outliers from Avg Calculations at the dimension level https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414838#M33385 <HTML><HEAD></HEAD><BODY><P>‌yes. I just want to exclude the upper outliers.</P></BODY></HTML> Mon, 20 Nov 2017 13:38:14 GMT https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414838#M33385 Anonymous 2017-11-20T13:38:14Z Re: Excluding Outliers from Avg Calculations at the dimension level https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414839#M33386 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Avg(Aggr(If(Values &lt;= Fractile(TOTAL &lt;Cat, Dates&gt; Values , 0.75) +&nbsp; 1.5 *(Fractile(TOTAL &lt;Cat, Dates&gt; Values , 0.75) - Fractile(TOTAL &lt;Cat, Dates&gt; Values , 0.25)), Values), Cat, Values, Dates))</STRONG></P></BODY></HTML> Mon, 20 Nov 2017 17:12:55 GMT https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414839#M33386 sunny_talwar 2017-11-20T17:12:55Z Re: Excluding Outliers from Avg Calculations at the dimension level https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414840#M33387 <HTML><HEAD></HEAD><BODY><P>When I tested your solution, the average is higher than the normal average calculation. That shouldn't be the case if we're excluding the upper outliers, Otherwise it works, just not with the numbers I expect</P></BODY></HTML> Mon, 20 Nov 2017 17:44:23 GMT https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414840#M33387 Anonymous 2017-11-20T17:44:23Z Re: Excluding Outliers from Avg Calculations at the dimension level https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414841#M33388 <HTML><HEAD></HEAD><BODY><P>I saw similar problem, but I am not sure what might be issue... Would you be able to share the raw data behind this app in an Excel file?</P></BODY></HTML> Mon, 20 Nov 2017 17:51:00 GMT https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414841#M33388 sunny_talwar 2017-11-20T17:51:00Z Re: Excluding Outliers from Avg Calculations at the dimension level https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414842#M33389 <HTML><HEAD></HEAD><BODY><P>Please find the raw data attached! I also noticed you're using Total in your outlier calculation and that will have a uniform outlier for all the dimension values. I want each dimension to have its own outlier</P></BODY></HTML> Mon, 20 Nov 2017 19:08:48 GMT https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414842#M33389 Anonymous 2017-11-20T19:08:48Z Re: Excluding Outliers from Avg Calculations at the dimension level https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414843#M33390 <HTML><HEAD></HEAD><BODY><P>I am heading out for the day today, but will try to take a look today in the evening or tomorrow morning.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Mon, 20 Nov 2017 19:13:36 GMT https://community.qlik.com/t5/App-Development/Excluding-Outliers-from-Avg-Calculations-at-the-dimension-level/m-p/1414843#M33390 sunny_talwar 2017-11-20T19:13:36Z