topic Calculating Average as Reference Line on Chart in QlikView

Calculating Average as Reference Line on Chart

QFanatic — Sat, 16 Nov 2024 00:59:28 GMT

hi all

Please find attached.

The model contains Volumes per Day, per Table.

On my chart, I want to display the (1) Average per day (of the selected month) and (2) Average per Hour. But the figures I am getting on Per Day seems too low, if I just look at the figures.

I was considering =avg(aggr(Sum({$<PERIOD={$(vMaxMonth)}>} HOUR_VOLUME)
/
count({$<PERIOD={$(vMaxMonth)}>} distinct REQ_DAY),PERIOD)) as well?

Any help will be appreciated? I'm not great with Averages...actually, I'm very Average 🙂 🙂

Thanks

Re: Calculating Average as Reference Line on Chart

Brett_Bleess — Wed, 15 Apr 2020 15:46:58 GMT

Have a look at the following Design Blog post, may prove helpful, but I am not sure:

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

Regards,
Brett

Re: Calculating Average as Reference Line on Chart

QFanatic — Fri, 17 Apr 2020 10:02:53 GMT

Thank you