https://community.qlik.com/t5/App-Development/Generate-Sum-When-Comparing-Dates-at-Regular-Intervals/m-p/1679381#M63774 <P><SPAN>I have a table displaying CUSTOMER and valid LICENSES in the form of a STARTING DATE and an END DATE (date interval). A license is always valid over a specific time period, e.g. from 1 January 2020 to 31 January 2020.</SPAN><BR /><SPAN>Now, I want to automatically generate a table that shows me the number of valid licenses for certain recurring appointments (specific dates), e.g. 1 January 2020, 8 January 2020, 15 January 2020 etc.</SPAN><BR /><BR /><SPAN>More plainly: Number of valid licenses at specific RECURRING DATES, i.e. whenever the RECURRING DATE is greater than STARTING DATE and less than END DATE.</SPAN><BR /><BR /><SPAN>How should I approach with SET ANALYSIS for this?</SPAN></P> Sat, 16 Nov 2024 19:02:30 GMT Qliker 2024-11-16T19:02:30Z https://community.qlik.com/t5/App-Development/Generate-Sum-When-Comparing-Dates-at-Regular-Intervals/m-p/1679381#M63774 <P><SPAN>I have a table displaying CUSTOMER and valid LICENSES in the form of a STARTING DATE and an END DATE (date interval). A license is always valid over a specific time period, e.g. from 1 January 2020 to 31 January 2020.</SPAN><BR /><SPAN>Now, I want to automatically generate a table that shows me the number of valid licenses for certain recurring appointments (specific dates), e.g. 1 January 2020, 8 January 2020, 15 January 2020 etc.</SPAN><BR /><BR /><SPAN>More plainly: Number of valid licenses at specific RECURRING DATES, i.e. whenever the RECURRING DATE is greater than STARTING DATE and less than END DATE.</SPAN><BR /><BR /><SPAN>How should I approach with SET ANALYSIS for this?</SPAN></P> Sat, 16 Nov 2024 19:02:30 GMT https://community.qlik.com/t5/App-Development/Generate-Sum-When-Comparing-Dates-at-Regular-Intervals/m-p/1679381#M63774 Qliker 2024-11-16T19:02:30Z