Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mgreen76
Contributor
Contributor

Display Data Within a Date Range

I have a table which contains an event with a start date and end date.

I want to display all data within a selected date range say for instance between 01/06/18 and 30/06/18.  my data could look like the following

EventID, Start Date, End Date

1, 01/06/18, 24/06/18

2, 25/06/18,  09/07/18

3, 01/05/18, 29/05/18

4, 13/05/18, 12/06/18

5, 24/05/18, null

 

If I selected my date range as 01/06/18 to 30/06/18 I would expect to see events 1,2,4 & 5 returned in my table as either the start or end date falls within my selected criteria (event 5 included as essentially the event is still ongoing).

Could anyone help with the easiest way to achieve this please.

4 Replies
sunny_talwar

I think what you might need is Interval Match

mgreen76
Contributor
Contributor
Author

I'm not sure how that would work.  The user will select a start date and end date within the dashboard and I just want the table to display any events where the start date or end date falls within the range.

sunny_talwar

How are the user selecting the start and end date? in a variable or in a field which has all the dates between the start and end dates?

mgreen76
Contributor
Contributor
Author

Hi,

 

Users will select a start and end date from input boxes which would be passed into variables.