topic Re: help me in creating Gantt chart with excel data in QlikView

help me in creating Gantt chart with excel data

Josn_Qlik356 — Fri, 15 Nov 2024 23:51:19 GMT

Hi All,

could you please guide me in creating Gantt chart with attached excel data

Thanks in advance,

Jason

@sunny_talwar

Re: help me in creating Gantt chart with excel data

edwin — Wed, 07 Oct 2020 01:33:30 GMT

try this expression:

=repeat(' ',RangeSum(Above(Sum(Duration), 1, RowNo() )) ) & repeat('X',sum(Duration))

Duration = the diff between finish - start + 1
make sure you sort by task start date
also use mono space font like COURIER so the space has same pixel as what character you will use

there are block chars i used before but cant find it rt now, but this should give you an idea

Re: help me in creating Gantt chart with excel data

Josn_Qlik356 — Wed, 07 Oct 2020 06:13:24 GMT

Thanks for your time.

could you please look at the qvw attached. getting error

Thanks,

Jason

Re: help me in creating Gantt chart with excel data

edwin — Fri, 09 Oct 2020 01:45:13 GMT

not sure how you wanted it to look like with the parent tasks. heres a sample idea with all the tasks

Re: help me in creating Gantt chart with excel data

Brett_Bleess — Thu, 22 Oct 2020 18:36:37 GMT

Have a look at the following Design Blog post, should be of some help:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Gantt-chart/ba-p/1469842

Regards,
Brett