Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Average over months

Hi Guys,

 YearMonthJanFebMar
Revenue2018£20.00£30.00£120.00
2019   
No of  jobs2018101824
2019   
Average Revenue2018£20.00£25.00£56.67
2019   
Average No of jobs2018101417
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

1 Solution

Accepted Solutions
Highlighted
Digital Support
Digital Support

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

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.

View solution in original post

2 Replies
Highlighted
Master
Master

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,

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Highlighted
Digital Support
Digital Support

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

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.

View solution in original post