Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
villegasi03
Creator
Creator

Issue with summing time using intervalmatch

I am having an issue with summing minutes using intervalmatch. I am currently loading the following.

scheduleEvents:
LOAD id, starttime, stoptime, ActivityTypeName from events;

intervalTable:
LOAD minute, timeRangeName from MinuteSheet.xlsx;

LEFT JOIN (intervalTable)
INTERVALMATCH (minute) LOAD  starttime,  stoptime RESIDENT scheduleEvents;
LEFT JOIN (intervalTable) LOAD * RESIDENT scheduleEvents;
DROP TABLE scheduleEvents;

Once loaded I am able to group by timeRangeName and count the the minutes field to get total time for the interval. The issue that I am having is the amount of resources its using and the shear size of the application. I had to scale my load down to a week worth of data at one time for 100 employee events.

I really want to increase about of days I am loading but I am scared that my terminal would explode if I did so. Is there anything that anyone recommends that might help me out with my issue.

Thank you,

0 Replies