Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arsenal1983
Creator
Creator

Statistic based on aggregated data

Hello,

I wonder if there is any way to calculate some basic statistics based on aggregated data.

I have the data set as below (full data set in attachment).

In addition to the simple average, I would like to calculate the median, decile distribution, standard dev and the Kurtosis. It would be also great to calculate some more sophisticated average that would ignore outliers observation (maybe the winsor average).

DAYS AFTER DELIVERSALE COUNT
0591 224
12 519 994
25 580 213
39 939 836
412 666 755
512 152 089
612 812 327
710 684 022
88 324 704
96 060 070
104 516 300
114 076 047
Labels (4)
3 Replies
tresesco
MVP
MVP

Qlik has some statistical functions  you might want to check.

arsenal1983
Creator
Creator
Author

know these functions but they do not work properly on aggregated data. For example on my whole data set I attached in previous post the median of 'DAYS AFTER DELIVER' - Median([DAYS AFTER DELIVER]) is 613 DAYS while in fact the correct value of median is around 8 days. That is because the median does not take into account differences in numbers (count) in 'DAYS AFTER DELIVER' bucket.

Brett_Bleess
Former Employee
Former Employee

Probably the best area to search would be the Design Blog area, here is one post I found on averages that may help with that particular piece:

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

Here is another one regarding integration with other third-party tools:

https://community.qlik.com/t5/Qlik-Design-Blog/Introducing-Qlik-Advanced-Analytics-Integration/ba-p/...

Here is the base URL to the area in case you wish to further search on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.