Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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