Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Regarding Interval Match


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

6 Replies
ecolomer
Master II
Master II

You have an example to see

Not applicable
Author

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

Interval Match or Inline load

Not applicable
Author

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

Not applicable
Author

Hi Bhanu,

thanks for your reply!!

Let me check with your example...

Regards

Sarfaraz

Anonymous
Not applicable
Author

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