topic Re. :Re: Interval Match in QlikView

Interval Match

Mon, 16 Aug 2010 10:40:01 GMT

Hey Guys.

Can anyone give me a good basic example of an interval match? Ive searched the forums but all the ones I came accross were a bit to confusing for me. I want to try and use Interval Match in one of my projects but I don't understand it properly.

Re. :Interval Match

martin59 — Mon, 16 Aug 2010 10:44:45 GMT

Hi,

Hope that helps you.

Re. :Interval Match

Mon, 16 Aug 2010 10:47:29 GMT

very nice, but theres one problem, its French and Im English lol

Re. :Re: Re. :Interval Match

martin59 — Mon, 16 Aug 2010 10:54:05 GMT

Sorry, i've forgot it ! I translate it now.

Re. :Re: Re. :Interval Match

martin59 — Mon, 16 Aug 2010 11:12:24 GMT

That's it !

Re. :Re: Re. :Interval Match

Mon, 16 Aug 2010 11:50:56 GMT

Thanks for the replies Martin i really appreciate it, however, I'm still not sure what to do to create an interval match. Maybe you can help me?

I want to create an nterval match between two fields, StartDate and EndDate.

LOAD StartDate,

EndDate;

SQL SELECT *

FROM Employee;

This is the first one and this is the second,

LOAD BusinessEntityID,

TerritoryID,

StartDate,

EndDate;

SQL SELECT *

FROM SalesTerritoryHistory;

Any Ideas?

Re. :Re: Re. :Interval Match

Mon, 16 Aug 2010 13:35:54 GMT

Anything?

Re. :Re: Re. :Re: Re. :Interval Match

martin59 — Mon, 16 Aug 2010 13:41:31 GMT

It's a certification, try to do it yourself.

Re. :Re: Re. :Re: Re. :Interval Match

Mon, 16 Aug 2010 13:44:16 GMT

i tried INTERVALMATCH (StartDate,EndDate); SELECT StartDate,EndDate FROM SalesTerritoryHistory; but its not working??

PLEEEEES HELP!!!!

Re. :Re: Re. :Re: Re. :Re: Re. :Interval Match

martin59 — Mon, 16 Aug 2010 13:47:57 GMT

Firstly, you have to use the intervalmatch function with only one argument.

So you have to do something like :

INTERVALMATCH (OrderDate)

Interval Match

Mon, 16 Aug 2010 14:00:31 GMT

Check this post http://community.qlik.com/forums/t/23510.aspx

I've tried to explain there how to replace IntervalMatch by usual Load statements. Maybe it can help.

Interval Match

Mon, 16 Aug 2010 14:38:02 GMT

Worked like a bomb. Thanks so so so much.

got another problem though. When the Interval Match completes, it creates a sysnthetic table. How do i get rid of that?

Interval Match

Caique_Zaniolo — Mon, 16 Aug 2010 14:51:27 GMT

Try a left join() to your main table.

Interval Match

Mon, 16 Aug 2010 14:52:23 GMT

I have already but its not working.

LEFT JOIN('MainTable')

Re. :Re: Interval Match

martin59 — Mon, 16 Aug 2010 14:53:11 GMT

LEFT JOIN(MainTable) // without quotes

Re. :Re: Interval Match

Mon, 16 Aug 2010 15:02:51 GMT

No that doesnt work...sorry...

Re. :Re: Re. :Re: Interval Match

martin59 — Mon, 16 Aug 2010 15:10:23 GMT

Could you send a screenshot of your data model ?

Re. :Re: Re. :Re: Interval Match

Mon, 16 Aug 2010 15:14:25 GMT

Re. :Re: Re. :Re: Interval Match

Mon, 16 Aug 2010 15:20:53 GMT

It will be better to see your load script.

Re. :Re: Re. :Re: Interval Match

Mon, 16 Aug 2010 15:27:38 GMT

its cool guys, i found this which helped me greatly,

http://community.qlik.com/forums/t/17847.aspx