Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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.