topic Re: Gantt Chart - Separate Transactions in QlikView

Gantt Chart - Separate Transactions

cbaqir — Mon, 31 Oct 2016 19:08:02 GMT

I am using a Gantt Chart to show a ticket process path. If you select DEFECT_ID 6742, you can see in the Gantt that ERC - Routing shows 4 days but if you look at the chart below, you will see that that step has 4 instances with different durations that total 4 days.

I created a key called DEFECT_GPQ_START in hopes that I could use this to separate the boxes in the Gantt so that instead of one box per Queue step, it shows one box per transaction... see current vs desired view. Anyone have an idea on how to do this?

Current:

Desired:

Re: Gantt Chart - Separate Transactions

Frank_Hartmann — Mon, 31 Oct 2016 21:48:24 GMT

have a look at attached sample

hope this helps

Re: Gantt Chart - Separate Transactions

cbaqir — Mon, 31 Oct 2016 22:25:27 GMT

Thanks, Frank, but I still need the buckets with the thresholds of <7, 7-14, >14 etc

Re: Gantt Chart - Separate Transactions

Frank_Hartmann — Tue, 01 Nov 2016 10:22:25 GMT

Hi Cassandra,

have a look at attached sample!

Hope this helps

Re: Gantt Chart - Separate Transactions

cbaqir — Tue, 01 Nov 2016 16:03:36 GMT

I appreciate the thought but have you seen my attached example? I need to keep the chart in that format with the Gantt chart look and the class (buckets by 7 days) but to separate the individual GOV_PROCESS_QUEUE_TAT as in my Desired photo.