topic Re: Average delivery by Month in QlikView

Average delivery by Month

sodavid — Fri, 01 Mar 2019 17:20:37 GMT

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)

Re: Average delivery by Month

sunny_talwar — Fri, 01 Mar 2019 17:27:58 GMT

May be try this

Avg(Delivery_Qty)

Re: Average delivery by Month

sodavid — Sat, 02 Mar 2019 18:03:17 GMT

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

Re: Average delivery by Month

Brett_Bleess — Tue, 12 Mar 2019 16:03:33 GMT

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