topic Average over months in QlikView

Average over months

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

Hi Guys,

	Year	Month	Jan	Feb	Mar
Revenue	2018	£20.00	£30.00	£120.00
2019
No of jobs	2018	10	18	24
2019
Average Revenue	2018	£20.00	£25.00	£56.67
2019
Average No of jobs	2018	10	14	17
2019

Example table above, I need to know the formula/function to use for the average values highlighted in red if possible. I need this to continue across for all 12 months.

Apologies am fairly new to Qlik and still getting used to it all 🙂

Many thanks,

Joe

Re: Average over months

Taoufiq_Zarra — Fri, 13 Dec 2019 14:30:02 GMT

Hi,

I didn't quite understand your need?

can you share a sample data and explain to us on this sample data the expected output

Cheers,

Re: Average over months

Brett_Bleess — Thu, 19 Dec 2019 20:21:29 GMT

Have a look at the following Design Blog post:

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

Here is the base Design Blog URL link in case you want to do some further searching for other posts that may be of help, there are hundreds in this area and most are how-to related...

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

Regards,
Brett