Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rajinikanth
Contributor III
Contributor III

Comparing two dates and check for not falling dates

Hi All

 

I have two tables as below.

Need to compare Date from T1 with Start_date and End_date from table 2  and pull only Dates that are not falling between. (Note : can do this by joining two tables, but the volume of data is huge so cant approach this solution).

Result should be 1-jan-2018,  as it doesn't fall between any of the satrt_date and end _date

T3:

Date
1-Jan-18

T1:

Date
1-Jan-18
23-Apr-18

T2:

satrt_dateend _date
31-Mar-1824-Feb-19
31-Mar-1824-Feb-19
Labels (4)
2 Replies
JordyWegman
Partner
Partner

Hi Rajinikanth,

You can do the following. Now you only get the dates who do not fall in between the dates.

IF(Date >= [start_date] AND <= [end_date],null(),Date)

Jordy

Climber 

Work smarter, not harder
rajinikanth
Contributor III
Contributor III
Author

This above solution, i can use when i have Date , start_date,end_date in one table.

I don't want these two tables to be joined, as my data is huge and hamper the performance with this join.