Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

IntervalMatch -- falling interval between two values

Hello,

I 'm dealing with the need of a field that indicates the interval that match for each event row. For that, I have both table EVENTS and INTERVALS but I don't know how to use the intervalmatch() function (For now I made this calculation with nested IF). Could you help me pls?

Qlik Sense Browser 25092014 104736 a.m..bmp.jpg

Thanx!!

1 Solution

Accepted Solutions
demoustier
Contributor

Re: Re: IntervalMatch -- falling interval between two values

like this ?

6 Replies
Employee
Employee

Re: IntervalMatch -- falling interval between two values

You could use something like:

intervalmatch(VALUE)

Load

MIN_VALUE, MAX_VALUE

Resident Interval_Table;

And join this table to the Intervalmatch table so as to eliminate the synthetic keys.

Not applicable

Re: IntervalMatch -- falling interval between two values

Hello,

Following statement should give you desired result based on your data (Interval Match creates a synthetic key)

IntervalMatch(Value)Load MIN_VALUE,MAX_VALUE Resident Interval;

Thanks

Amit Prabhudesai

demoustier
Contributor

Re: IntervalMatch -- falling interval between two values

Something like this ?

IntervallMatch is definitively the good option. Difficulties are coming from tables jointure.

test2 is result without synthetic key

Not applicable

Re: IntervalMatch -- falling interval between two values

Thanx, but what if I want not only these two fields "MinValue" and "MaxValue" but the other fields from the events table? How can I merge it ?

demoustier
Contributor

Re: Re: IntervalMatch -- falling interval between two values

like this ?

Not applicable

Re: Re: IntervalMatch -- falling interval between two values

It's perfect Demoustier! Thanx very much!!

Community Browser