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

[mrichman]

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! 

[Claudiu_Anghelescu]

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

[sergio0592 · Accepted solution]

Hi,

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

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

[mrichman]

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...