Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
cbaqirdhds
Valued Contributor

Gantt and Straight table by Input Box Date Range

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

Tags (3)
2 Replies
cbaqirdhds
Valued Contributor

Re: Gantt and Straight table by Input Box Date Range

Anyone?

MVP & Luminary
MVP & Luminary

Re: Gantt and Straight table by Input Box Date Range

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