topic Re: Check a Date Field is Between 2 date fields From TableB in scripting in App Development

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

ChristopherFeng — Fri, 12 Sep 2025 14:30:58 GMT

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?

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

Oleg_Troyansky — Fri, 12 Sep 2025 15:53:13 GMT

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

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

ChristopherFeng — Mon, 15 Sep 2025 19:27:55 GMT

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?