Trigger with multiple field expression?

[#1]

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.

[ecolomer]

I had a similar problem and I resolved

I generate a Calendar with limits ...

FEC_LIM:

LOAD

  Min("DEBUT_CHANTIER") as FechaMin,

  Max("FIN_CHANTIER") as FechaMax

resident TAR;

LET vMin=num(Peek('FechaMin',0,'FEC_LIM'));

LET vMax=num(Peek('FechaMax',0,'FEC_LIM'));

CAL:

LOAD

  Date(IterNo()+$(vMin)-1)   as CFecha,

  Year(Date(IterNo()+$(vMin)-1)) as CAño,

  Month(Date(IterNo()+$(vMin)-1))  as CMes,

  Week(Date(IterNo()+$(vMin)-1))   as CSemana,

  WeekStart(Date(IterNo()+$(vMin)-1)) as CSemIni,

  WeekEnd(Date(IterNo()+$(vMin)-1)) as CSemFin

  AutoGenerate 1 While IterNo()+$(vMin)-1<=$(vMax);

Ans select the dates ...