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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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