Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
darrin_pilkingt
Creator II
Creator II

Are there limits with intervalmatch?

I would think the answer is no but here is my problem.

I am working with a single days worth of call records and my load script with intervalmatch is working just fine.  When I run the script for 6 months worth of data, 30+ million records, the same data I validated before that worked no longer does.

So are there limits interval match?

Thank you.

1 Solution

Accepted Solutions
Henric_Cronström

There are no "hard" limits. But you may run into memory problems if you have large data sets. Sometimes a While loop is a better option (uses less memory) than an IntervalMatch. See http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates

HIC

View solution in original post

2 Replies
Henric_Cronström

There are no "hard" limits. But you may run into memory problems if you have large data sets. Sometimes a While loop is a better option (uses less memory) than an IntervalMatch. See http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates

HIC

View solution in original post

darrin_pilkingt
Creator II
Creator II
Author

Henric,

Thank you very much.  I didn't go the way of the article you linked but did reference your article IntervalMatch and Slowly Changing Dimensions

The memory problem got me thinking and I remembered your part about

"The Autonumber() function converts the string to an integer that takes a lot less memory space."

The use of AutoNumber(AgentID & ' | ' & Num(StartDateTime) & ' | ' & Num(EndDateTime)) as [AgentID+Interval] really helped speed things up and use less memory.  It made me also think of other areas I could save on memory consumption earlier in the load script.

Thanks

But now you spawned a new question I will open a new post on in regards to intervalmatch and incremental loads.