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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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 !

Labels (1)
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.