topic Open intervals with IntervalMatch in QlikView

Open intervals with IntervalMatch

Fri, 17 Feb 2012 09:48:28 GMT

Is there a way to have open intervalsused with the intervalmatch function?

Sice normally closed intervals are taken, as stated on page 243 of the Reference Manual: "The intervals are always closed, i.e. the end points are included in the interval."

What I would need are intervals that are only closed on one side:

[0,10)

[10,20)

[20,30)

So that in the end the dataseries with value "20" is not associated with two series of 10.

Any ideas?

Cheers,

Jonas

Re: Open intervals with IntervalMatch

lironbaram — Fri, 17 Feb 2012 10:54:23 GMT

check the attach file this is the meathod i use

hope it helps you

Re: Open intervals with IntervalMatch

nstefaniuk — Fri, 17 Feb 2012 16:04:23 GMT

Hi.

In french you have this article. The text is in french but the code in application is in english.

http://www.bleent.com/qlikview-utiliser-intervalmatch-avec-des-intervalles-ouverts/