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: 
151562
Contributor II
Contributor II

Percentage of people by age group

I would like to know how I can calculate the percentage of people per age group when the age group changes that year.
For example, a person who is 49 and turns 50 is counting in both age groups and I just wanted to count the maximum of the age group

151562_0-1684514624594.png

 

Thank you,
FPS
Labels (1)
1 Solution

Accepted Solutions
151562
Contributor II
Contributor II
Author

I've solved the problem
instead of calculating the age by day of birth, I calculated by year of birth
Then I created the age range from age by year

Thank you,
FPS

View solution in original post

2 Replies
Chanty4u
MVP
MVP

Try this

Count(PersonID) / Count(TOTAL <Year> PersonID)

151562
Contributor II
Contributor II
Author

I've solved the problem
instead of calculating the age by day of birth, I calculated by year of birth
Then I created the age range from age by year

Thank you,
FPS