Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You have an example to see
you can have a look at the below link there is a nice example
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
Hi Bhanu,
thanks for your reply!!
Let me check with your example...
Regards
Sarfaraz
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