topic Re: Gantt chart in QlikView

Gantt chart

emmanueld — Mon, 10 Jul 2017 07:13:51 GMT

Hello,

I'm currently working on a prototype app which includes a Gantt Chart. I had a few ideas which converge with the following article :

Recipe for a Gantt chart

This lead me to the following, with four dates and three durations

I was wondering about :

- the possibility to display another text on hover?

=> the difference between date 2 and date 1 is a number of days, but on display it is converted to date format.

- the possibility to display the DT1 value before the bar? Or to write M1 inside the blue bar, M2 inside the brown bar, M3 inside the gray bar.

Here is a demo app. Only colors are different.

Thank you!

Re: Gantt chart

Anil_Babu_Samineni — Mon, 10 Jul 2017 07:23:22 GMT

Because, You are considering and written as Date format in Number tab? Change it to number rather Date format

Re: Gantt chart

avinashelite — Mon, 10 Jul 2017 07:23:37 GMT

n the number tab you have made the expressions has date hence its showing it in the date format ...make it expression default and make you expression result according to your required format

Hope this helps you

Re: Gantt chart

emmanueld — Mon, 10 Jul 2017 07:55:47 GMT

Thank you Anil. Indeed I had tried to set expressions (DT1 to DT2, DT2 to DT3 ) as "number" instead of "date"' but then the axis becomes a number too...

In your example, it looks like you "cheated" by making DT1 to DT2 a "date" with format DD, but then the displayed number is not the number of days between DT1 and DT2, it's the DD part of "DT1 to DT2" converted to date.

Re: Gantt chart

emmanueld — Mon, 10 Jul 2017 07:57:14 GMT

"DT2 to DT3" and "DT3 to DT4" are good though

Re: Gantt chart

Anil_Babu_Samineni — Mon, 10 Jul 2017 07:59:44 GMT

My bad, I've changes to only Number from number tab. If remaining two working then you must change the first one to number only.

Re: Gantt chart

emmanueld — Mon, 10 Jul 2017 08:09:07 GMT

Does your axis still show the dates? Mine doesn't if I set the 3 expressions to Number in number tab.

Re: Gantt chart

emmanueld — Mon, 10 Jul 2017 08:12:47 GMT

Thank you Avinash, however if I set the first three expressions as "expression default" or "number", then the axis becomes a number too, which is worse! (please refer to my answer to Anil) Unless you know a way to keep both a number in the bar and a date in the axis?

Re: Gantt chart

Anil_Babu_Samineni — Mon, 10 Jul 2017 08:33:21 GMT

Will you explain, Where you are getting the Years(X-Axis) ???

Re: Gantt chart

emmanueld — Mon, 10 Jul 2017 08:48:07 GMT

The years that are shown in the axis in the first app I've shared are just due to the values of "DT1 to DT2" bar offset + the three expressions, and to the values of Milestone_DT1, Milestone_DT2, Milestone_DT3,Milestone_DT4.

They are date values, but because of the range/precision/zoom of the graph, it automatically shows the Year. With different Load inline values (narrower range), you would get DD/MM/YYYY in the axis (Try load inline with only PRJ0 that is commented in the script).

Re: Gantt chart

emmanueld — Wed, 12 Jul 2017 10:01:09 GMT

Otherwise, is there a way to just hide the on-hover window?

What about

"- the possibility of displaying the DT1 value before the bar? Or to write text 'M1' inside the blue bar, 'M2' inside the brown bar, 'M3' inside the gray bar."?