Gantt and Straight table by Input Box Date Range

[cbaqir]

I have a Gantt chart and a Straight table that is used to display overlapping events. I need the user to be able to add a date range and display all tasks that overlap those dates in any way. How can I do this?

Sample attached.

Thanks,

Cassandra

[cbaqir]

Anyone?

[rwunderlich]

I think if you change the expression to:

Max(TASK_END_DATE)

-Min(

{<TASK_START_DATE={">=$(vEventStartDate)<=$(vEventEndDate)"}> + <TASK_END_DATE={">=$(vEventStartDate)<=$(vEventEndDate)"}>}

TASK_START_DATE)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com