topic Re: Unique intervals in QlikView

Unique intervals

MindaugasBacius — Wed, 28 Dec 2016 09:59:23 GMT

Hello,

I have data like this (see the attachment):

I need to have unique intervals without overlapping intervals.

The outcome should be like this:

There are few ways to get the correct result. But unfortunately I cannot come up with the correct logic here.

Thank you in advance!

Gysbert_Wassenaar — Wed, 28 Dec 2016 10:10:15 GMT

I'm afraid I don't understand the result you want. The first two rows in your outcome screenshot show two intervals that overlap.

MindaugasBacius — Wed, 28 Dec 2016 10:18:21 GMT

E and F columns shows rows that should be deleted or kept in the result.

There are two ways to make it correct but it depends on how you manage the issue. Both outputs suit me.

Gysbert_Wassenaar — Wed, 28 Dec 2016 10:28:06 GMT

It's still not clear to me. But have a look at page 17 and 18 of the pdf file attached to this document: IntervalMatch and Slowly Changing Dimensions

raajaswin — Wed, 28 Dec 2016 10:44:53 GMT

I think this is what you want.. It gives column F value

maxgro — Wed, 28 Dec 2016 10:48:35 GMT

my attempt in the attachment

MindaugasBacius — Tue, 03 Jan 2017 07:46:28 GMT

Could you please take a look at this issue: