topic Re: Gant Diagramm Question 2 in QlikView

Gant Diagramm Question 2

rolandg1881 — Sun, 07 Mar 2021 15:00:44 GMT

Hi!

Follwing Question to the specialists.

I have a Productiondate where 10 Pieces of a product where produced. Example Produktiondte 20.01.2020

Then i have some delivery Dates to this product Example 02.02.2020 3 pieces, 05.03.2020 5 pieces and 08.04.2020 2 pieces.

Now i want to make a Gant Diagramm where i can see this progress on a timeline.

Thank you for help.

Greetings Roland

Re: Gant Diagramm Question 2

marcus_sommer — Mon, 08 Mar 2021 14:38:54 GMT

This will be helpful for such a task:

Files for creation of a Gantt chart - Qlik Community - 1487079

How to create a Gantt chart using a Pivot table - Qlik Community - 1479233

- Marcus

Re: Gant Diagramm Question 2

rolandg1881 — Mon, 08 Mar 2021 16:42:30 GMT

Thanks! It's interesting.

But there is always a Duration. I have only "Points" Exapmle. Productiondate 20.01.20 and then the following "Ponits" in the Timeline Deliverydate 1 02.02.20, Deliverydate 2 05.03.20 etc.

For me ist would be ideal to see the Timeline in months . Produced in February, First Delivery in March, second Delivery in Mai etc. on one Timeline...

Thanks

Re: Gant Diagramm Question 2

marcus_sommer — Tue, 09 Mar 2021 08:21:24 GMT

You may need to adjust your datamodel to be able to apply such a view whereby I'm not sure that yours isn't already feasible for it even if it looked a bit different respectively it may easy changeable to such a logic. If you have multiple date-fields you should consider to transform them with The Crosstable Load - Qlik Community - 1468083.

As far as you have a date you have also all possible deductions from it, for example with: month(Date).

- Marcus

Re: Gant Diagramm Question 2

rolandg1881 — Tue, 09 Mar 2021 18:18:47 GMT

Thank you! I will try this.

Greetings

Roland