Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
amien
Specialist
Specialist

what doesn't this extended intervalmatch work?

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?

2 Replies
swuehl
MVP
MVP

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
Specialist
Specialist
Author

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

Thanks for your reply