Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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