Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 (1)
2 Replies
Highlighted
Contributor III
Contributor III

Re: Count of Eligible Members who have a date range

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

Highlighted
Partner
Partner

Re: Count of Eligible Members who have a date range