Re: Average delivery by Month - Qlik Community

sodavid · ‎2019-03-01

I am new here and trying to develop a dashboard with average deliveries by month. I would expect my average delivery qty in Jan for supplier AABC = 2092. I tried the expression below but the average calculation seems to be wrong. Thanks in advance

Sum( Delivery_Qty) / count({<Supplier>} total distinct Month)

sunny_talwar · ‎2019-03-01

May be try this

Avg(Delivery_Qty)

sodavid · ‎2019-03-02

Thanks. works perfect. avg(Delivery_Qty):)..That simple.

Brett_Bleess · ‎2019-03-12

Sodavid, is it possible for you to click the Accept as Solution on the post that got you what you needed? This way things get noted as solved, so other people looking for things will know this one was actually solved and not just answered.

You are also going to see the post move, we are trying to get things into the correct spots, sorry for the inconvenience on that.

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.