topic Re: Looking up a range in the script in QlikView

Looking up a range in the script

danielact — Wed, 11 Apr 2012 17:44:55 GMT

I have 2 tables I'm loading in a script. One has a bunch of dates for individual contracts - let's call the field ContractDate. The other table has a bunch of date ranges. It would look like this:

DateRange StartDate EndDate

1 1/1/2011 2/5/2011

2 2/6/2011 3/11/2011

3 3/12/2011 3/31/2011

and so on. The two tables are not linked by any common fields. I want to look up the date on the first table and get the corresponding Date Range that the date falls into.

Any ideas on how to do that?

Looking up a range in the script

CELAMBARASAN — Wed, 11 Apr 2012 17:53:11 GMT

Hi,

You mean one to one mapping?(first record to first record)

Celambarasan

Looking up a range in the script

Wed, 11 Apr 2012 18:13:22 GMT

IntervalMatch()

Looking up a range in the script

danielact — Wed, 11 Apr 2012 19:18:20 GMT

This looks like the right function, but I can't get it to work... can you help me out with the syntax?

The date field in Table 1 is called ContractDate. I already entered the layout of Table 2 above.

Re: Looking up a range in the script

Wed, 11 Apr 2012 19:24:05 GMT

it could be: IntervalMatch ( ContractDate) Load StartDate, EndDate resident TableWithStartDateAndEndDateFields;

upload a reduced version of your QVW and I'll help you with it.

Re: Looking up a range in the script

danielact — Wed, 11 Apr 2012 19:34:27 GMT

Here you go

Re: Looking up a range in the script

Wed, 11 Apr 2012 19:38:23 GMT

here you go, with just one final table.

Re: Looking up a range in the script

danielact — Wed, 11 Apr 2012 19:49:17 GMT

Thanks a lot!

Re: Looking up a range in the script

Sat, 02 Jan 2016 13:55:09 GMT

Hi! i really want to see the syntex of the answer too.

but my Qlickview is personal edition so i cannot open this file,

can u please just copy for me it in an answer???