Interval Match not working after Feb QS update

[jialiangyao]

Hi all,

Is anyone else experiencing wrong results when using Interval Match in the load script where dates are concerned?

Thank you.

[Anil_Babu_Samineni]

How is your script looks like?

[jialiangyao]

I have a whole list of transactions with vendor information. 

Based on the time of the transaction, I want to match information such as their respective categories or their consolidated vendor name.

My script is as such. 

AllTransactionDates:

load

Ref.Transaction Date,

Ref.Vendor Number

from xxx.QVD;

[Reference_Table]:

LOAD
Ref.Date,
Ref.Vendor Number,
Ref.Consolidated Vendor Name,
Ref.Supplier Categorization
Resident qReference_Table
Order By Ref.Vendor Number, Ref.Date Desc
;

// Lastly, Interval Match criteria
Inner Join IntervalMatch ("Ref.Transaction Date","Ref.Vendor Number")
Load
"Ref.FromDate",
"Ref.ToDate",
"Ref.Vendor Number"
Resident Reference_Table;

[jialiangyao]

What I find strange is that when I load the exact same script in the Sept release of QlikSense, it gives me the expected results. 

However, when I load that same script in the Feb 19 release of QlikSense, it gives me blank values.

Creating dummy data to test the intervalmatch function gives me correct values, so I am baffled as to why this might happen.

Wondering if anyone else encountered such a situation so it can help narrow down my troubleshooting process.