Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie777
Partner - Creator III
Partner - Creator III

Visualizing the length of period (like employment length)

Hello,

I'd like to create a visualization for employee's tenure in the company.  In Power BI, I was able to do that using a disconnected tables of the calendar table and employee database fact table which contains the information on hiring dates and leaving dates.  I'd like the visualization to look like below, with alphabet A to E being the names of employees and years in the horizontal axis.  I'd like to see it in a consecutive line where the start point represents the hiring date and the end point represents leaving date so that we can visualize the time length.  Please could you let me know how I can do that?  

Newbie7_0-1623226751049.png

Tank you for your help!

2 Replies
GaryGiles
Specialist
Specialist

There is a nice example of a Gantt chart in the Qonnections 2019 Top 10 Viz posted by Patric Nordstrom that should accomplish what you are looking for.  Link below:

https://community.qlik.com/t5/Documents/Top-10-Viz-tips-Qonnections-2019-Part-I/ta-p/1580174

Newbie777
Partner - Creator III
Partner - Creator III
Author

Thanks for the advice!