topic Re: Intervalmatch when end time is lower than start time in QlikView

Intervalmatch when end time is lower than start time

stabben23 — Thu, 06 Oct 2016 10:14:37 GMT

Hi all,

I have used intervalmatch and it Works almost Perfect. The problem is that I have start time at 06:44:00 and end time 00:53:00

If I use this as my intervall Field it wont work. I have right now end time 23:59:59 to get it to work.

Do anyone have a smart way to modify the last 53 min? Idont want to generate all times between 00:54 to 06:43 just as a workaround.

Re: Intervalmatch when end time is lower than start time

jonathandienst — Thu, 06 Oct 2016 10:25:52 GMT

The problem is that you are using time only - if you convert these times to timestamps with day portion, then you will not have end times "before" start times. But that may nt work very well for interval matching.

One possible solution is to convert the data to a start time and a duration, but that depends on what you are trying to do with the interval match. If you provide more information, with a small sample qvw and details of the results you require, you will get more specific help.

Re: Intervalmatch when end time is lower than start time

stabben23 — Thu, 06 Oct 2016 10:37:35 GMT

Hi Jonathan,

here is a sample!

Re: Intervalmatch when end time is lower than start time

stabben23 — Thu, 06 Oct 2016 10:44:38 GMT

I could add some kind of dummy date to get a Whole timestamp and then "delete" the date part from it.

Like start time 2016-01-01 06:44:00 end time 2016-01-02 00:53:00. but maybe there is a "smoother" way.