Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
cbaqirdhds
Valued Contributor

Gantt Chart - Separate Transactions

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:

10-31-2016 12-00-30 PM.jpg

Desired:

10-31-2016 12-00-30 PM.jpg

Tags (1)
4 Replies
Frank_Hartmann
Honored Contributor

Re: Gantt Chart - Separate Transactions

have a look at attached sample

hope this helps

cbaqirdhds
Valued Contributor

Re: Gantt Chart - Separate Transactions

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

Frank_Hartmann
Honored Contributor

Re: Gantt Chart - Separate Transactions

Hi Cassandra,

have a look at attached sample!

Hope this helps

cbaqirdhds
Valued Contributor

Re: Gantt Chart - Separate Transactions

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.