topic Interval Match in QlikView

Interval Match

Fri, 10 Feb 2012 07:44:54 GMT

Hi all,

I need assistance with interval match.

I have a table with the StartDate (2011/01/29 00:01) and EndDate (2011/01/29 00:05), both these have time in them. My second table I am loading has minutes of the day, eg 00:01, 00:02, etc. What I am trying to do is create an intervalmatch that will give me intervals that the start date and end date fall under. in this call the interval would be 05, as in that transaction happened in the 5 minute interval.

I am using this to check intervals when people sing in and out of the building.

Your assistance will be highly appreciated.

Re: Interval Match

hic — Fri, 10 Feb 2012 08:25:52 GMT

You should look at the Class function. I would probably do something like

TimeStamp(Class(Time, 5/24/60)) as TimeInterval

Interval Match

Fri, 10 Feb 2012 08:46:55 GMT

Hi Henric,

Sorry but I dont understand. Do i do the class function on the check in time or check out?

And must I ignore trying to do the intervalmatch on the minutes table I loaded?

Interval Match

CELAMBARASAN — Fri, 10 Feb 2012 08:58:19 GMT

Hi,

Check with the interval function and create a separate field for this Interval(EndDate-StartDate,'hh:mm') as somefield name same as the field that you need to classify using the second table you will get the difference in minutes.

Hope it helps

Celambarasan

Interval Match

hic — Fri, 10 Feb 2012 09:24:58 GMT

If you want to convert a time to an interval - like a lookup - then you should use the class function in the script. And you should perhaps use it for both StartTime and EndTime. Depends on what to you want to display if StartDate belongs to one interval and EndDate belongs to another...

Intervalmatch is used when you have times in one table and the intervals defined in a second table and you want to link them both.

The Interval function that Celambarasan points at is used if you have time spans that you want to format as intervals in minutes.