Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH 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.