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: 
Anonymous
Not applicable

Negative Time with IntervalMatch

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.

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

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

];

View solution in original post

3 Replies
Clever_Anjos
Employee
Employee

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

];

Anonymous
Not applicable
Author

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

Clever_Anjos
Employee
Employee

Are you asking if its possible?