Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Selecting a range of dates

I have two dates in a table, start date and end date.  I want the user to be able to select a range, and have it select all records that are assocated with that range.  Is there a way to do this, even in a macro?  I have been successful in getting it to select over a range by only looking at the start date of the record.  Unfortunately, there are records not being selected that should be because the specified end date would qualify it for the selection.

Thanks...

1 Reply
cesaraccardi
Not applicable

Selecting a range of dates

Hi Therese,
Try using the intervalmatch() function to create date intervals, you could generate all the dates between your very starting date and the last ending date. And so your selections in those fields would be applyed to the calendar. I hope this help you.

Regards,
Cesar