Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

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

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! 

 

QlikCommunity130820198.PNG

1 Solution

Accepted Solutions
Specialist III
Specialist III

Hi,

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

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

 

View solution in original post

3 Replies
Specialist
Specialist

https://community.qlik.com/t5/Qlik-Sense-App-Development/Avg-and-Month-Dimension-on-chart/m-p/161113...
To help community find solutions, please don't forget to mark as correct.
Specialist III
Specialist III

Hi,

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

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

 

View solution in original post

Creator II
Creator II

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