topic Re: Heat Map Gantt/Dates? in QlikView

Heat Map Gantt/Dates?

cbaqir — Fri, 21 Aug 2015 16:38:55 GMT

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.

thanks!

Cassandra

Re: Heat Map Gantt/Dates?

Anonymous — Fri, 21 Aug 2015 16:42:15 GMT

please can you post sample data cassandra , so can help

Re: Heat Map Gantt/Dates?

cbaqir — Fri, 21 Aug 2015 17:05:59 GMT

Sample Data Attached

Re: Heat Map Gantt/Dates?

Anonymous — Sat, 22 Aug 2015 08:58:50 GMT

Hi,

Thanks,will update once solution is done.

Re: Heat Map Gantt/Dates?

cbaqir — Tue, 25 Aug 2015 16:00:02 GMT

Any luck?

Re: Heat Map Gantt/Dates?

Anonymous — Tue, 25 Aug 2015 16:05:18 GMT

Hi Cassandra,

no luck as yet

Regards

Neetha

Re: Heat Map Gantt/Dates?

cbaqir — Wed, 26 Aug 2015 20:46:29 GMT

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.

Re: Heat Map Gantt/Dates?

cbaqir — Wed, 02 Sep 2015 20:51:02 GMT

Still looking for some help with this from someone.