Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.