topic Re: How can I change bar chart to average depending on selected date? in QlikView

How can I change bar chart to average depending on selected date?

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

Hi Community,

I have a bar chart with a range of dates, each having its own value. Is it possible, when I select 3 months (see picture), then the bar charts will show averages on all.. so 07/2019,08/2019 and 09/2019 showing all 25?

Thanks in advance!

Re: How can I change bar chart to average depending on selected date?

Claudiu_Anghelescu — Tue, 13 Aug 2019 07:26:40 GMT

https://community.qlik.com/t5/Qlik-Sense-App-Development/Avg-and-Month-Dimension-on-chart/m-p/1611134#M45430

Re: How can I change bar chart to average depending on selected date?

sergio0592 — Tue, 13 Aug 2019 08:47:34 GMT

Hi,

Add a line with the following expression. See the attached .qvw

avg(TOTAL AGGR(sum(Value),Date))

Re: How can I change bar chart to average depending on selected date?

mrichman — Wed, 14 Aug 2019 06:45:18 GMT

Hi Sergio, Thanks for the prompt reply! It's working for this case, however my "real" case has different rows with the same value (see link). Do you probably know how I could best approach this?

Thanks in advance!

https://community.qlik.com/t5/New-to-QlikView/Dimension-not-grouping-tried-Aggr-also-not-working/m-p/1611481#M379177