Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
praveenpurush6
Contributor III
Contributor III

Showing Milestones from Date in Table

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.

2 Replies
lorenzoconforti
Specialist II
Specialist II

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
Contributor III
Contributor III
Author

Thanks Lorenzo.
I will try with Crosstable.