topic Bar Graph - Average bar in QlikView

Bar Graph - Average bar

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

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

basav — Tue, 30 Jun 2020 06:40:27 GMT

Hey Daniel,

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

cheers,

Basav

Brett_Bleess — Wed, 08 Jul 2020 18:19:18 GMT

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

Regards,
Brett