Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Adding intervalls to total time

Hi

I have a problem trying to add different intervalls to a total amount of time. Im suspecting i have to use INtervallmatch somehow.


I have the following:

BlackoutID   Customer ID  START                          STOP                              Total time

1                       A                2012-01-01 12:30      2012-01-01 14:00                    1:30

1                       B                2012-01-01 15:00      2012-01-01 16:00                    1:00

.                        .                                   .                         .                                         .

2                       A                 2012-01-01 15:00      2012-01-01 16:00                   1:00

.                        .                                   .                                                           

.                        .                                   .

.                        .                                   .

5                       A                 2012-01-01 18:30      2012-01-02 18:00                   23:30

5                       B                 2012-01-02 14:30      2012-01-03 07:00                   16:30

...                        ...               ...                                   ...                                             ...

If the time between Different BlackoutIDs but the same Customer ID is less than two hours, i would like the total time to be added up.

Example: Blackout iD=1 and Customer A has a blackout from 2012-01-01 12:30 to 14:00, total 1:30. but Blackout ID=2 and customer A has blackout from 15:00 to 16:00 the same day.I would then like to combine these two blackouts to one blackout starting 2012-01-01 12:30 to 16:00, total time 3:30. Is this possible?

I have QV 10.

Thx in advance!
//Andreas

Community Browser