I'm trying to add a feature in my Qlikview application where a user can search for eligible movies based on a date range.
I have an object called Movie, it looks like this:
Movie
-------
MovieId
MovieName
WindowStart (MM/DD/YYYY)
WindowEnd (MM/DD/YYYY)
In my QlikView application, I want a user to be able to select a date range, and if at least one day within a movie's time window falls within that date range, it should show up as an eligible result. Right now, I have two calendar objects, Start Date and End Date. Both of them are selecting variables named vStartDate and vEndDate, respectively.
I'm trying to add a trigger action when either variable changes. I need the expression to look like this logic:
All movies within:
vStartDate<= MovieEnd <= vEndDate OR
vStartDate<= MovieBegin <= vEndDate OR
(MovieBegin <= vStartDate AND MovieEnd >= vEndDate
It's that third scenario that has me stumped. I don't know how to add multiple fields and then have the expression use both fields in the trigger action.
