Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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