Creating a simple Gantt for a dashboard using Interval Match
There is no native Gantt chart in QlikView. A simple one can be created using a bar chart with bar offset, or a more advanced one can be created by using extension objects (there are some examples of this available online).
In this example, we will use a native QlikView straight table to represent a simple Gantt for use in a dashboard.
Getting ready
Load the following script:
Project: Load * Inline [ ProjectID, ProjectName, StartDate, EndDate 1, First Project, 2013-01-01, 2013-06-30 2, Second Project, 2013-02-01, 2013-07-31 3, Third Project, 2013-03-01, 2013-05-31 4, Fourth Project, 2013-04-01, 2013-08-31 5, Fifth Project, 2013-05-01, 2013-10-31 ]; Let vMinDate=Floor(MakeDate(2013)); Let ...
Get QlikView for Developers Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
