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: 
qlikmpate0
Creator II
Creator II

Intervalmatch for dates

Can you use interval match without Id's?

I have an orders table containing ordered dates, I want to use  interval match to get all orders for a current period, future and all orders year to date.

can any one help?

2 Replies
petter
Partner - Champion III
Partner - Champion III

Best practice for doing this is to use a calendar and not IntervalMatch. It might certainly be use cases that are valid for doing an IntervalMatch but without having more details I would suggest that you have a very close look at how a calendar with fields and flags for various standard periods can help you.

ramoncova06
Partner - Specialist III
Partner - Specialist III

here is one link that might help

QlikView App: Dates, Date Ranges and Set Analysis