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: 
stevegimbrollmt
Creator II
Creator II

Time IntervalMatch - Not fully working

Hi, I am a bit confused here,

So I have a Start Time (hh:mm:ss) and an Endtime (hh:mm:ss)  I have created an inline table like the following and after created an intervalmatch with the proper data to link this interval with how many events happened in those 30mins.  It did work for many records but got a huge chunk of data as nulls meaning it did not match.

Time Intervals Table

Range is split in 30mins.  Now I have connected it with a Tournament table where Im checking how many activities happened in each 30mins range and added the intervalmatch like this

TimeList:

load

Hour, time(Hour_Min) as Hour_Mina  , time(Hour_Max) as Hour_Maxa  ,

Hour_Min & '-' & Hour_Max as HourInterval

Resident TimeListTemp;

DROP TABLE TimeListTemp;

RENAME Field Hour_Mina to Hour_Min;

RENAME Field Hour_Maxa to Hour_Max;

TimeIntervals:

IntervalMatch(ConvertedStartTime) load

  Hour_Min , Hour_Max Resident TimeList;

Why would some of this data  (sample) not match?

Start time has been converted to Time : time(maketime(Hour(StartTime), Minute(StartTime),Second(StartTime)),'hh:mm:ss TT') as ConvertedStartTime

Not sure if I explained my self well but if not let me know,  also from 23:30 till 00:00.. there are no matches when in reality there is data

1 Solution

Accepted Solutions
stevegimbrollmt
Creator II
Creator II
Author

Ok, seems today is my day,

I have found a way to sort out the range 23:30:00 to 00:00:00

I have done this but changing the 00:00:00 to 23:59:60

It worked fine as the interval captured till 23:59:59

View solution in original post

2 Replies
stevegimbrollmt
Creator II
Creator II
Author

So most of this I can answer my self

This morning seems I been fresh so I have noticed that the time not captured was always the same so I checked the time ranges and realised that I had a missing couple of 30mins intervals hence the no matches.

I also noticed that if the range is from 23:30:00 to 00:00:00. it does not work but from 23:30:30 to 23:59:59 it picks up the data up to 23:59:58 leaving out 23:59:59

Any idea what I can do to capture the 23:59:59 data within that range?

Thanks

stevegimbrollmt
Creator II
Creator II
Author

Ok, seems today is my day,

I have found a way to sort out the range 23:30:00 to 00:00:00

I have done this but changing the 00:00:00 to 23:59:60

It worked fine as the interval captured till 23:59:59