Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ptl14495
Contributor III
Contributor III

Use 2 dates and get results in a 3rd date

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

StartexpirationContract Analysis CalendarContracts Active
01/01/201031/12/201501/01/2018               -    
01/01/201231/12/201601/01/2018               -    
01/01/201531/12/201801/01/2018                1  

 

What formula can i use in Qlik Sense?

 

thank you

Labels (1)
0 Replies