topic what doesn't this extended intervalmatch work? in QlikView

what doesn't this extended intervalmatch work?

amien — Mon, 21 Nov 2011 20:22:58 GMT

Inline:

Users, Year, Min, Max

List:

Numbers, Year2

INNER JOIN (Inline)

//intermatch:

INTERVALMATCH (Numbers, Year2)

LOAD DISTINCT Min,Max, Year as Year2

RESIDENT Inline;

DROP TABLE List;

the intervalmatch self is fine .. but the years is not picked up for some reason. This is the correct syntax right?

swuehl — Mon, 21 Nov 2011 20:57:32 GMT

I would guess that you need a inner join (List), but I don't really got what you want to do.

Maybe you could post a more complete script snippet with some sample data and describe what the expected result should look like?

amien — Fri, 25 Nov 2011 23:04:08 GMT

is was a year mismatch problem. I have put a NUM before each year, and it worked.

Thanks for your reply