TABLE OF CONTENTS
- Representation - Text
- Representation - Indicators
- Representation - Progress
- Representation - Bulletchart
- Representation - Minichart
- Representation - Box Plot
- Column, Totals
Vizlib Table supports up to 100 measures. When you add a measure (Figure 1) you can choose to enable Master measure formatting, which means formatting for the measure will be taken from the master item definition (you can find master items in the Custom Objects menu in the left hand panel). You can also add a condition in Calculate column if which runs if the condition is met. Visibility Condition is a legacy feature - if the condition is met (an expression can be entered), then the column is hidden in the Qlik Sense hub, but will appear in the export file.
Figure 1: Measure
You can add a Measure Title (using HTML if you need to), set the Tooltip Mode and Tooltip Color for Title Tooltip and set the Tooltip Content and Tooltip Color for Cells Tooltip (Figure 2).
Figure 2: Title
You can enable a Title icon for the table (Figure 3) choosing an icon, an Icon Color and the Icon Position while also customizing the Title Horizontal Alignment and Title Coloring. You can also set a fixed column width with Adjust Column Width.
Figure 3: Icon
You can set the Cell Text Color, Cell Background Color, Null Value Bg color and Null Value color, as well as choose the Cell Font style and add a Drop Shadow. There are also settings for changing the Cell Horizontal Alignment and Cell Vertical Alignment and an option to use Advanced CSS Styling by entering an expression (Figure 4).
Figure 4: Cell
Representation - Text
There are 6 different Representation types for measures which display the measure as an object - you can choose from Text, Indicators, Progress, Minichart, Bulletchart and Boxplot. Figure 5 shows a Text representation, which can be entered as HTML or in a URL format by selecting the checkboxes. If you select Text as HTML you can start to use images within your table.
Figure 5: Text Representation
To use images, enter the image source into the Expression field (Figure 6).
Figure 6: Expression
We've included an example in Figure 7, with the output in the table and an example code structure, with the condition that the image changes if the City field has the value Seattle (Figure 8).
Figure 7: Example
Figure 8: Code Example
Representation - Indicators
If you use Indicators (Figure 9.1 to 9.4), you can set different colors and icons to display values where you can choose to have single values (Figure 9.1) or a ranges (Figure 9.2 to 9.4).
Figure 9.1: single value indicator ranges
Figure 9.2: Indicator ranges based on rules
Figure 9.3: Change the Operator to 1 of 5 values
Figure 9.4: End result of indicator ranges
Representation - Progress
If you choose a Progress representation (Figure 10) you'll display the measure as a progress bar. You can set the Bar Scale, customize the Progress Bar Colors and display Negative bars, as well as displaying a value inside the bar with Show Value.
Figure 10: Progress Bar
Representation - Bulletchart
If you want to use a Bulletchart representation (Figure 11) to display measure data, you can choose to Show Bullet Data Label, and customize the Values appearance by setting an Actual color, a Target, a Target Width and Target Color. You can also define multiple Range values and set the Range color for each value.
Figure 11: Bulletchart
Representation - Minichart
With MiniChart representations you can insert a chart into each table row, displaying the measure across the dimension provided for the mini chart. In version 3.16.0 of Vizlib Table (and above), Minicharts now support expressions with multiple parts and set analysis in all parts of the expression.
Note: The dimension must be a single field and cannot be a calculated dimension.
To display the minichart settings, select an option from the Minichart Type dropdown (Line chart, Bar chart, Combo chart, Pie chart, Stacked bar chart and Multiline are currently available). Figures 12 and 13 show the settings for a bar chart. You'll see the Minichart Dimension displayed, and you can choose to Use same start date and customize the Minichart Height.
Figure 12: Minichart Barchart
For a bar chart, you can set the Bar Color, Negative Bar Color, enter a Max. Amount of Bars, choose to Show First 50 Bars, set the Bar Width, Bar Spacing and display a Zero Axis.
Figure 13: Minichart Barchart
We've summarized the main features for each mini chart option in Table 1.
Table 1: Minichart Features
|Line chart||Line color, Area Color, Line Width, Data Points Representation, Data Point Radius, Highlight Points (Coloring Intervals, Highlight Point Radius, Highlight Last Point (Last Point Color), Highlight Max Point (Max Point Color), Highlight Min Point (Min Point Color), Range (Min value, Max value, Range Color).|
Bar Color, Negative Bar Color, Max. Amount of Bars, Show First 50 Bars, Bar Width, Bar Spacing, Zero Axis.
|Combo chart||Settings for Line Chart and Bar Chart (see above).|
|Pie chart||Colors (Scheme or comma separated Hex codes).|
|Stacked bar chart||Max. Amount of Bars, cShow First 50 Bars, Bar Width, Bar Spacing, Colors. Negative bars not supported.|
|Multiline||Line Name, Line Expression, Line Width, Data Points Representation, Data Point Radius, Highlight Points (Coloring Intervals, Highlight Point Radius, Highlight Last Point (Last Point Color), Highlight Max Point (Max Point Color), Highlight Min Point (Min Point Color), Range (Min value, Max value, Range Color).|
Representation - Box Plot
Like a minichart, a Box plot representation (Figure 13) can be inserted into each table row, displaying the measure across the dimension, which is defined in Box plot Dimension. You can choose the Box Line Color, Box Fill Color, Box Whisker Color and Box Median Color.
Figure 13: Box Plot
The last group of measure settings (Figure 14) let you display the Right Column Border, setting the Border color and Border Thickness. You can also display the measure as Relative to total, enable Show Total and select a Totals Function option. You can also choose to add Vizlib Actions or a Master Item.
Figure 14: Column Border, Totals
If you click on Add Action, you'll open the Vizlib Actions settings (Figure 15), where you can Pick Action to select the action you want, enter a Field, set the action to Dynamic / Static and enter a Field Value. The action runs when you select a cell, and you can have multiple actions for the same measure.
Note on Actions: If you enable Allow Measure Selection in the Interactivity settings, you won't be able to use Vizlib Actions with measures.
Figure 15: Vizlib Actions
Figure 16 shows an example Vizlib Table in "Bloomberg" format, with a text representation (1), an indicator (2), a minichart (3) and a progress bar (4).
Figure 16: Example Table
Figure 17 shows a minichart using emojis and flags.
repeat('❤ ', rangemax(ceil(max(rand()*10)),1))
Figure 17: Emojis