topic Re: Negative Time with IntervalMatch in QlikView

Negative Time with IntervalMatch

Anonymous — Fri, 09 Oct 2015 18:10:54 GMT

It's possible to make the Intervalmatch function recognizes negatives hh:mm:ss? The first range of Load Inline below only recognizes the positive intervals ...

Intervals:

load * inline

[

Time_Start ,Time_End,DSC_INTERVAL

-01:00:00,-02:00:00, -1 Hour

00:00:00,01:00:00, 1 Hours

01:00:01,02:00:00, 2 Hours

02:00:01,03:00:00, 3 Hours

03:00:01,99:99:99,+3 Hours

];

Thanks.

Re: Negative Time with IntervalMatch

Clever_Anjos — Fri, 09 Oct 2015 18:13:23 GMT

First value should be the lowest

Try

Intervals:

load * inline

[

Time_Start ,Time_End,DSC_INTERVAL

-02:00:00,-01:00:00, -1 Hour

00:00:00,01:00:00, 1 Hours

01:00:01,02:00:00, 2 Hours

02:00:01,03:00:00, 3 Hours

03:00:01,99:99:99,+3 Hours

];

Re: Negative Time with IntervalMatch

Anonymous — Fri, 09 Oct 2015 18:15:16 GMT

Thanks! It's possible to use the negative time between () too.

Re: Negative Time with IntervalMatch

Clever_Anjos — Fri, 09 Oct 2015 18:16:41 GMT

Are you asking if its possible?