Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Population between 2 dates

I have a table of people with a date of Birth and a date of death if the person is deceased.

I want to be able to select a range of dates and have a counter of population alive during that period.

I guess the way QV works, I need to generate a table containing a person alive for each date that exists between the earliest DOB and today.

How can I script this?

My table people table has

person_id,

date_of_birth,

date_of_death

Thank you !

10 Replies
Not applicable
Author

Could you please share your qvw file.

I am same facing the same problem but not regarding the population but the data related with my work.