Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
cbaqirdhds
Valued Contributor

Heat Map Gantt/Dates?

I have a requirement to show the following type of heat map based on overlapping dates of tasks.

I've found a couple of heat map videos but those are using expressions such as Sum(profit) and not dates. Any idea on how I could achieve the data below? Each TASK has a TASK_START_DATE and a TASK_END_DATE.

8-21-2015 9-35-52 AM.gif

thanks!

Cassandra

7 Replies
neetha_p
Honored Contributor

Re: Heat Map Gantt/Dates?

please can you post sample data cassandra , so can help

cbaqirdhds
Valued Contributor

Re: Heat Map Gantt/Dates?

Sample Data Attached

neetha_p
Honored Contributor

Re: Heat Map Gantt/Dates?

Hi,

Thanks,will update once solution is done.

cbaqirdhds
Valued Contributor

Re: Heat Map Gantt/Dates?

Any luck?

neetha_p
Honored Contributor

Re: Heat Map Gantt/Dates?

Hi Cassandra,

no luck as yet

Regards

Neetha

cbaqirdhds
Valued Contributor

Re: Heat Map Gantt/Dates?

So... maybe I need something like if a.start_date <= b.end_date AND b.start_date < a.end_date then 1 else 0? I'm not sure how I would define what a or b is though... it could be across several filters.

cbaqirdhds
Valued Contributor

Re: Heat Map Gantt/Dates?

Still looking for some help with this from someone.