topic Re: Avgerage, Median or something in QlikView

Avgerage, Median or something

Thu, 22 May 2014 11:51:50 GMT

Hi,

I have following table. I need to get overall avergae days for applications. If I take avg then it's not correct. what should I use?

App_ID	Days taken
123456	-
123458	-
321456	-
519454	-
717452	-
915450	-
915450	-
915450	-
915450	122
915450	1

Re: Avgerage, Median or something

ThornOfCrowns — Thu, 22 May 2014 11:53:49 GMT

What do you think the average of those rows is and what does AVG bring back?

Re: Avgerage, Median or something

Thu, 22 May 2014 11:58:12 GMT

avg gives me 61.5 but it's not correct. Can I exclude 122 and then take avg of the rest

Re: Avgerage, Median or something

amit_saini — Thu, 22 May 2014 12:14:14 GMT

Hi Shoaib,

Just want to check if you have did the same for average cal or not?

Total mode should be set as "Average"

Thanks,
AS

Re: Avgerage, Median or something

ThornOfCrowns — Thu, 22 May 2014 12:26:06 GMT

61.5 is the average of those rows. If you want to exclude the outlier, look at Gysbert Wassenaar's answer in this thread: http://community.qlik.com/thread/102661

Re: Avgerage, Median or something

Fri, 23 May 2014 11:17:17 GMT

Thanks James. I tried the thread which you mentioned but it did not work. I used a formula to calculate avg time in expression as below. Now I want to get rid of outliers under this expression. Could you please tell how can I use Gysbert Wassenaar logic using this expression.

Channel Rework
22.9
50.2
65.2
N/A
N/A
N/A
4.8
2.1
N/A
0.7
N/A
N/A
10.1
N/A
N/A
344.2