topic Re: Gantt and Straight table by Input Box Date Range in QlikView

Gantt and Straight table by Input Box Date Range

cbaqir — Tue, 29 Sep 2015 19:15:53 GMT

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

Re: Gantt and Straight table by Input Box Date Range

cbaqir — Mon, 05 Oct 2015 19:59:32 GMT

Anyone?

Re: Gantt and Straight table by Input Box Date Range

rwunderlich — Tue, 27 Oct 2015 23:16:28 GMT

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