Check a Date Field is Between 2 date fields From TableB in scripting

[ChristopherFeng]

i have two tables:

• TableA(MonthYearEmployee,MonthlyDate, EmployeeNumber)
• TableB(EmployeeNumber,StartDate,EndDate,FullName)

I need to represent a table visual with EmployeeNumber, MonthYear, FullName but the MontlyDate from TableA should be between StartDate and EndDate on TableB to bring the right FullName.

How can i do this in script level in qlik sense?

[Oleg_Troyansky · Accepted solution]

Hi @ChristopherFeng ,

Look up the INTERVALMATCH feature. That's what you need to associate distinct date/time events with ranges of dates.

I'm going to cover this topic in detail in my Qlik Expert Class in Vienna, which starts in 10 days - on September 22nd, among many other advanced data modeling techniques, scripting, AGGR, Set Analysis, and more. You could learn a lot if you can join.

Cheers,

Oleg Troyansky

[ChristopherFeng]

Can i use IntervalMatch like this:
IntervalMatch(MonthlyDate, EmployeeNumber)

Load StartDate,EndDate 

Resident TableB;

Is this correct or should i use only MonthlyDate in IntervalMatch?