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: 
sicdude
Contributor III
Contributor III

Count of Eligible Members who have a date range

I'm trying to figure out how I can find if a member is eligible with a specfic filtered date range and get a count of each member eligible.   Each member has a begin date and an end date.  A member can be eligible within the filtered date range if :

1. Their begin date falls within the range

2. Their End Date falls within the date range

3. Their Begin date is prior to the beginning of the date range and End Date is after the end of the date range

Begin and End date are in a seperate "Member"  table outside of where the main data table. Houses the eligiblity range, first name, last name ect...

 

Labels (2)
2 Replies
sicdude
Contributor III
Contributor III
Author

believe that I found a possible solution for this 

https://community.qlik.com/t5/Qlik-Design-Blog/Creating-Reference-Dates-for-Intervals/ba-p/1463944

this will create a table with a member and their eligibility dates, one record for every date that the member is eligible.  I can then count distinct as needed

javiersassen
Partner - Contributor III
Partner - Contributor III