Hi,
I want to know how many contracts i have signed in a specific date.
For this i will use Contract's start and expiration date.
Example bellow
Start | expiration | Contract Analysis Calendar | Contracts Active |
01/01/2010 | 31/12/2015 | 01/01/2018 | - |
01/01/2012 | 31/12/2016 | 01/01/2018 | - |
01/01/2015 | 31/12/2018 | 01/01/2018 | 1 |
What formula can i use in Qlik Sense?
thank you