help me in creating Gantt chart with excel data

[Josn_Qlik356]

Hi All,

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

Thanks in advance,

Jason

@sunny_talwar 

[edwin]

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

[Josn_Qlik356]

Thanks for your time.

could you please look at the qvw attached. getting error

Thanks,

Jason

[edwin · Accepted solution]

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

[Brett_Bleess]

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