topic Re: Gantt chart in QlikView

Gantt chart

shree909 — Mon, 03 Dec 2012 16:01:49 GMT

Hi i have bar chart which has to be shown as a gantt chart.

i have one dimension and 6 expressions , which have start date and end date.

so i plotted everything is done.

when i hover on the bars it shows the date as 12/08/1899.

so why its happenning????

for first expression i took floor( start date - enddate).. same thing for the next 5 expressions....

so when ever i hover on the chart it has to show the enddate on the bar .. is that possible..

and also if possible i want to show the enddate for the each expressions..

i tried on show value by using end date .. but still it shows some 1900...

have anyone came across tthis type of issues..

please find the attachedment..

so when u hover on the graph it shows durationa as 1900-1-1-

Re: Gantt chart

kouroshkarimi — Mon, 03 Dec 2012 16:05:04 GMT

You might find the following blog posts quite handy - they worked for me:

http://www.qlikviewaddict.com/2012/06/gantt-charts-in-qlikview.html

http://oneqlikatatime.blogspot.co.uk/2012/07/qlikview-charts-with-colours.html

Re: Gantt chart

shree909 — Mon, 03 Dec 2012 22:50:26 GMT

plz can anyone reply..

Re: Gantt chart

sujeetsingh — Tue, 04 Dec 2012 06:11:40 GMT

Hi dude i am not able to get details of chat to be followed in your sample qvw..plz Explain

Re: Gantt chart

hic — Tue, 04 Dec 2012 08:20:38 GMT

This is unfortunately how QlikView works when you use bars with offsets: It shows the number for the bar and not the value of offset+bar. This means that the value will be small and when displayed as date, it corresponds to 1899 or 1900.

You can add an additional number in the pop-up by adding an expression that is not shown as bar - but just as pop-up.

HIC

Re: Gantt chart

Wed, 30 Oct 2013 20:35:26 GMT

Have you checked out this Gantt chart extension?

http://webofwork.com/index.php/19-qlikview-tips-and-tutorials/90-qlikview-gantt-chart

Re: Gantt chart

Anonymous — Sun, 08 Apr 2018 09:54:57 GMT

file's not available, could you please re-upload?

Re: Gantt chart

andre_tonini — Thu, 04 Oct 2018 12:25:01 GMT

bom dia!

consegue nos passar esse .qvw?

att,

André Tonini

Controladoria