Showing Milestones from Date in Table

[praveenpurush6]

Hi All,
I am trying to create a Chart where I can show the Dates as milestones in the chart. I tried with reference lines but sometimes the reference line labels are overlapping.

Instead of reference line can we show this by symbols or like a gantt chart like the attached image?

Thanks,

Praveen.

[lorenzoconforti]

You need first of all your data to have une dimension per task; do a crossover table on your data in your loading script (Crosstable ‒ QlikView). If you are having problems with this load your data inline in your script; also, you would need the end date of each task, not just the beginning (to make the chart easier to build)

After you have this a Gantt chart is fairly straightforward; it would be just a bar chart, displayed horizontally with each bar's length being the duration of the task and each bar would be offset by the start date of the task. There's a good example here: creating Gantt Chart in Qlikview

[praveenpurush6]

Thanks Lorenzo.
I will try with Crosstable.