Date with IntervalMatch

terezagr — Wed, 01 Apr 2015 10:28:22 GMT

I have an application where I am using Interval Match to pick applications between two dates.

The Interval_Start and Interval_End are in integer format. These are then connected to a Calendar table where all dates for these intervals are held.

I want to achieve in my application this:

1. User selects a Start date (this will have unique Interval_Start identifier)

2. User selects an End date (this will have again unique Interval_End identifier)

3. All applications where changes were made will be shown along with the dates.

My data model looks like this:

I have created a table and can see all the changes that have been made in a period of time between 25/10/2012 up till 16/11/2012. However, I cannot see the interval dates when these changes were made:

Any ideas what am I doing wrong?

Re: Date with IntervalMatch

terezagr — Wed, 01 Apr 2015 11:52:36 GMT

Ok, by using set analysis

=Only({<DATE={"<=$(vStarDateSelection)>=$(vEndDateSelection)"}>}DATE)

I was able to generate these dates:

Although, 1 date for Interval_Start 679279 is still missing and I do not understand why! This Date is in the interval specified and it should be 29/10/2012.

Any suggestions?

topic Date with IntervalMatch in QlikView

Date with IntervalMatch

Re: Date with IntervalMatch