Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Open intervals with IntervalMatch

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

1 Solution

Accepted Solutions
Highlighted
lironbaram
Honored Contributor II

Re: Open intervals with IntervalMatch

hi

check the attach file this is the meathod i use

hope it helps you

2 Replies
Highlighted
lironbaram
Honored Contributor II

Re: Open intervals with IntervalMatch

hi

check the attach file this is the meathod i use

hope it helps you

nstefaniuk
Contributor III

Re: Open intervals with IntervalMatch

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/