Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

Average Daily Population Count

avg(aggr(count([ID]),[Date]) ) seems to be not working. I want to get the daily average number of persons by year and month and display in a bar graph, that changes dynamically from year to month 

1 Reply
Or
MVP
MVP

That formula appears to be correct. What exactly is the problem you are having with it?

Load * Inline [
ID, Date, Month
1, 1, A
2, 1, A
3, 1, A
2, 2, B
5, 2, B
3, 3, B
1, 3, B
1, 3, B
];

Or_0-1647285280469.png