Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Bar Graph - Average bar

Dear all,

I have a bar graph that shows weekly changes in volumes (see attachment).

The expression is Sum({<trade_type_group_cd={'Future'}>}abs_pos_vol) and I select the weeks I require to compare.

Is there a way to have a third bar showing the average volumes over the last x number of weeks (say 8 for example)?

Any help will be much appreciated.

Thanks
Daniel

2 Replies
Highlighted
Contributor III
Contributor III

Re: Bar Graph - Average bar

Hey Daniel, 

Have you tried the combo chart, you can show the average as a line chart. 

Please refer this link for more info: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Combo%20Chart.h...

cheers,

Basav

 

Highlighted
Digital Support
Digital Support

Re: Bar Graph - Average bar

Have a look at the following Design Blog post, might be of some use on this one:

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

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.