topic Re: compare month prodution with average prodution in Qlik Learning Discussions

compare month prodution with average prodution

Fri, 12 Sep 2014 22:06:12 GMT

hi, this is my firt post and this is my first project

i have this table

this one i can create

but i can't create this one

the total is calculated by adding the total of each january (4+6+6)

and the avarege is the avarege of (4,6,6) i.e in this case (4+6+6)/3

can anyone help me.

thaks

marcus_sommer — Sat, 13 Sep 2014 00:31:40 GMT

Try this: avg(aggr(sum(qty), year))

- Marcus

ecolomer — Sat, 13 Sep 2014 03:16:21 GMT

Your formula for calculate average are wrong

you can use:

Sum(total) / count(distinct year)

Sum(qty) / count(distinct year)

avg(aggr(sum(qty), year)

MK_QSL — Sat, 13 Sep 2014 08:17:20 GMT

Check enclosed file....

Sat, 13 Sep 2014 08:30:18 GMT

i only have to add the month

avg(aggr(sum(qty), year, month))

the average its ok, but it returns the average of my selection, i want the average of all the data.

thanks

Sat, 13 Sep 2014 08:38:24 GMT

i think its this

avg({1}aggr({1}sum({1}qty)), year, month))

thaks to all

MK_QSL — Sat, 13 Sep 2014 08:41:22 GMT

it should be

SUM({1}qty)

and

Avg({1}Aggr(SUM({1}qty),Year))