Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Generate Sum When Comparing Dates at Regular Intervals

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.
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.

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.

How should I approach with SET ANALYSIS for this?

0 Replies