Creating a heat gantt chart

Mon, 16 Mar 2015 17:20:53 GMT

Hi,

Hopefully you can help.

I have created a gantt chart within my document which shows what activity a customer did on what day. (The top chart within the image) <-- This was the easy bit!

What I am struggling on is to create the bottom chart in the image. I want to be able to show for all customers there activity pattern while on holiday. i.e. 100% of all tourists do activity 4 on days 7&8 but for some reason 15% of them do it on day 2.

I don't know if this can somehow be done on overlaying bars? As you can see for the top chart there are gaps between activities so I cannot use a stacked chart. Or maybe somehow use a formula in the colour of the bar (but I thought the bar all had to be one continuous colour?)

I have a worrying feeling that this cannot be done. I have managed to mock this up in a table and use a formula within the table to highlight the specific days, but typically in a table it only shows the days when you have activity so in the example provided days 1&2 in the first chart would not appear.

Any help would be greatly appreciated.

Thanks

PLEASE NOTE THAT THE ATTACHED IMAGE HAS BEEN MOCKED UP IN PAINT FOR ILLUSTRATIVE PURPOSES

Re: Creating a heat gantt chart

peterderrington — Fri, 25 Nov 2016 10:57:23 GMT

Did you manage to get anywhere with this?

I'm looking to produce a similar thing with my Gantt chart but i can't see how to do it.

Thanks,

Peter

topic Re: Creating a heat gantt chart in QlikView

Creating a heat gantt chart

Re: Creating a heat gantt chart