TABLE OF CONTENTS
Vizlib Gantt supports from one to four Dimensions, which are added and defined in the Dimensions section of the property panel (Figure 1).
Figure 1: Add Dimension
The first dimension is defined as an Event, and the subsequent dimensions are defined as Hierarchies. No Metrics are required for Vizlib Gantt.
Why not try our sample load script below?
(today() - (rand()*200)) as Date,
(today() - (rand()*200)) as StartDate,
(today() - (rand()*200)) as EndDate,
'Event ' & mod(TransID,26)+1 as Event,
Pick(Ceil(3*Rand1),'A','B','C') as ParentGroup,
Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as Group,
Pick(Ceil(3*Rand()),'X','Y','Z') as SubGroup;
Rand() as Rand1,
IterNo() as TransLineID,
RecNo() as TransID
While Rand()<=0.5 or IterNo()=1;
Uncheck Include null values (Figure 2) if you need to have null values suppressed in the chart.
Figure 2: Null Values
In the Representation setting (Figure 3), one Dimension has to be defined as Event and up to three can be added as Hierarchies.
Figure 3: Representation
Settings for Events (Figure 4) are defined in the properties for the event dimension, and they're shown as bars or milestones in the timeline.
Note: If you want to display Tags for events, you will need to specify an End Date and Duration.
Figure 4: Events
You can set the Start date by using an expression and defining the type.
Figure 5: Start Date
To set an End Date, you select the End Date type and use an expression (Figure 6).
Figure 6: End Date
To set a Duration, select the Duration type and use an expression (Figure 7).
Figure 7: Duration
You can see an example in Figure 8.
Figure 8: Example
You can also choose to customize bar/milestone Color, Font Color and Tooltip settings (Figure 10), either by using the Color picker, entering a HEX color code (#FFFFFF is white), or choosing an RGB code. You can find out more about RGB codes in Qlik Sense here.
Figure 10: Color, Font Color, Tooltip
Event bars have a Progress Bar option (Figure 11) you can enable to calculate custom progress.
Figure 11: Event Bar
You can then show progress against your target e.g. duration/completion spend/budget (Figure 12).
Figure 12: Custom Progress
The property panel also includes an option to show text outside of the event bars in Event Bar Styling if it's required (Figure 13).
Figure 13: Outside Bars
Note: This feature currently has a limitation, as label names displayed outside the event bars will only be partially visible. The full label name can be displayed by using tooltip and hovering the cursor over the label.
Hierarchy properties are defined in the property panel under the remaining dimensions. In the Groups section, Show group header shows a header bar for groups, using the earliest event start date and latest event end date (Figure 14).
Figure 14: Group Header
Under Group header color settings you can enable Auto mode or define a custom colour using the colour palette, selecting to color by Group (Figure 15), Group hierarchy or expression.
Figure 15: Group Header Color
Show group progress bar calculates group progress bars from the progress bar values shown in each group (Figure 16).
Figure 16: Group Progress Bar
You can use Tags to add further context to event bars and customer event bars, and you can add them inside or outside the event bar. If you're using
Tag properties are found in the Event Bar Styling menu (Figure 17).
Figure 17: Tag Properties
Tags can be used to highlight aspects of KPIs within a chart e.g. resource, delays, budget. Figure 18 contains an example where ❌ flags an event as Late.
Figure 18: Tag Example