topic Re: Help with monthly rolling AVG in QlikView

Help with monthly rolling AVG

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have data with list of item nos for which i want to show avg for last 2/3 month.

I have attached test qvw which consist data for only one item no.

Tried formula: =avg(Consumed) & =aggr(Avg(Consumed),MONTH,[Item No])

however its not showing proper avg..

Would like to show monthly avg for all item no in pivot table & for some items in text box like shown in above image.

prat1507 — Tue, 03 Oct 2017 10:58:16 GMT

Use

=(FirstSortedValue(Aggr(Sum(Consumed), MONTH,[Item No]), Aggr(Sum(DISTINCT(MONTH)), MONTH,[Item No]), 1)

+FirstSortedValue(Aggr(Sum(Consumed), MONTH,[Item No]), Aggr(Sum(DISTINCT(MONTH)), MONTH,[Item No]), 2))/2

ajaysingh29 — Tue, 03 Oct 2017 10:58:52 GMT

Try this:

=AVG(Aggr(sum(Consumed),MONTH,[Item No]))

Anonymous — Tue, 03 Oct 2017 11:01:37 GMT

Thank you