topic Re: Display Data Within a Date Range in QlikView

Display Data Within a Date Range

mgreen76 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Display Data Within a Date Range

sunny_talwar — Mon, 14 Jan 2019 12:54:21 GMT

I think what you might need is Interval Match

Re: Display Data Within a Date Range

mgreen76 — Mon, 14 Jan 2019 12:59:20 GMT

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.

Re: Display Data Within a Date Range

sunny_talwar — Mon, 14 Jan 2019 13:01:44 GMT

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?

Re: Display Data Within a Date Range

mgreen76 — Mon, 14 Jan 2019 13:43:41 GMT

Hi,

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