Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

conwayro
New Contributor

Calculate and display daily average total in a date range on a combo chart

Hello,

I have a combo chart showing monthly totals of an event with 'MonthYear' coming from a master calendar.  I'm trying to add a second line (the existing line is just a linear trend line), which shows the daily average of the events/month and is dynamic enough to adjust as the date dimensions change i.e selected year/qtr/month/week etc..  The chart is below.

Capture.PNG

Any assistance is greatly appreciated!

1 Reply
Support
Support

Re: Calculate and display daily average total in a date range on a combo chart

Hey Roger, try searching on the Design Blog area, here is the link:

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

Not sure if there is anything direct there, but may be something that will give you some ideas.  

Including the Help for Reference Lines too just in case, that might help a tad too:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Reference_Lines...

If you really need help with the expression for the line, be sure to confirm that, and you may want to attach a small sample app folks can look at to help with that in that case.

Regards,
Brett

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.