topic Re: Regarding Interval Match in QlikView

Regarding Interval Match

Fri, 12 Sep 2014 12:46:09 GMT

Hi Everyone,

Can anybody explain me what is Interval Match function ..I gone through the reference manual also ...but i did not understand clearly..

Regards

Sarfaraz

Re: Regarding Interval Match

ecolomer — Fri, 12 Sep 2014 12:48:29 GMT

You have an example to see

Re: Regarding Interval Match

ecolomer — Fri, 12 Sep 2014 12:49:27 GMT

Re: Regarding Interval Match

Fri, 12 Sep 2014 12:51:28 GMT

you can have a look at the below link there is a nice example

Interval Match or Inline load

Re: Regarding Interval Match

Tue, 16 Sep 2014 05:29:32 GMT

Hi Enrique,

Thanks for your reply !!

I gone through the link which you mentioned below ...nice example but still little bit i am confused ...the QVW file which you attached here is not opening in my Side...

It is saying that " Your Qlikview Installation has exceeded the maximum number document recoveries allowed for personel addition liscence.To continue using the Qlikview you need to purchase the Qlikview Liscence ".

Tell me how i will be able or how can open the above attached document.

Regards

Sarfaraz

Re: Regarding Interval Match

Tue, 16 Sep 2014 05:31:11 GMT

Hi Bhanu,

thanks for your reply!!

Let me check with your example...

Regards

Sarfaraz

Re: Regarding Interval Match

Anonymous — Tue, 16 Sep 2014 06:14:26 GMT

Hi Sarfaraz,

Interval match function is used just for the finding the interval between two things like as below script we find the date interval between Cntrct_From, Cntrct_To datefield. Please have a look as below script

Data:

LOAD * INLINE [Date, Key1, Other

2010-01-01, A, z

2010-02-01, A, a

2010-03-01, A, z

2010-04-01, A, b

2010-05-01, A, d

2010-06-01, A, e

2010-01-01, B, f

2010-02-01, B, t

2010-03-01, B, k

2010-04-01, B, e

2010-05-01, B, z

2010-06-01, B, a];

// ===== Load the Contract ================================================

Contract:

LOAD * INLINE [Cntrct_From, Cntrct_To, Key1, Val

2010-01-01, 2010-12-31, A, 5

2010-01-01, 2010-03-30, B, 3

2010-04-01, 2010-12-31, B, 4];

// ==== Link Fields from Data with Contract into the Contract-Table ========

INNER JOIN INTERVALMATCH (Date, Key1) LOAD Cntrct_From, Cntrct_To, Key1 RESIDENT Contract;

// ==== Join into one Table only, remove contract-Data =====================

JOIN (Data) LOAD * RESIDENT Contract;

DROP TABLE Contract;

DROP FIELD Cntrct_From, Cntrct_To;

Hope this would be helpful for u.

Thanks