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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Want to display start and ending month graphically like in a Histogram

Hello,

I am brand new to Qlik and have been tasked with recreate in Qlik a project status timeline that currently exists in Excel. The blue time portion in the screenshot below is supposed to represent the ProjectStartDate and the PlannedCompletionDate. I have created a Calendar table but only linked it to the ProjectCompleteDate.

My first guess was to represent this in a Histogram with the undisplayed ProjectName field as a Dimension and the PlannedCompletionDate as an expression, but that is not working. Can someone make any suggestions for doing this or point me to how I can research further how to get this done? It doesn't necessarily have to be a histogram but we want the date range to be displayed graphically.

timeline.png

2 Replies
JonnyPoole
Former Employee
Former Employee

Gantt chart might be a good method to search for something like this:

How to create a Gantt chart using a Pivot table

Not applicable
Author

Thanks for the Gantt chart suggestion Jonathan! I'll give those instructions a try and post an update.