Using interval match function

Anonymous — Tue, 19 Jul 2011 12:35:10 GMT

Hi all,

I have got contracts with a start- and enddate.

Now I would like to use the interval match function in the script, but I don't know exactly how to do that.

I have got a table CONTRACTS, with all the relevant data. And I have a table CALENDAR which I use to check if a contract is valid or invalid.

Anyone who can help on this one?

At this moment I use a the following expression to get this done:

if(Startdate <= Date and Enddate >= Date, 'Valid')

The problem with this thing is that the performance is realy bad.

I hope someone can help me.

Cheers,
Henco

Tue, 19 Jul 2011 12:58:39 GMT

I hope the below code works (not tested)

Load personname,startdate,enddate from Contracts;
load date from Calender;
Intervalmatch (date) select startdate,enddate from contracts;

Now create one table box and add.

Personname,startdate,enddate,date and see the results.

hope this helps
Talha

topic Using interval match function in QlikView