Vizlib Table Properties - Data - Measures, Representations and Minicharts

TABLE OF CONTENTS

• Measures
• Title
• Icon
• Cell 
• Representation - Text
• Representation - Indicators
• Representation - Progress
• Representation - Bulletchart
• Representation - Minichart
• Representation - Box Plot
• Column, Totals
• Actions
• Examples

Measures

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

Back to Contents

Title

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

Back to Contents

Icon

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

Back to Contents

Cell 

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

Back to Contents

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

Back to Contents

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

Back to Contents

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

Back to Contents

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

Back to Contents

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

Back to Contents

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

Back to Contents

Column, Totals

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

Back to Contents

Actions

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

Back to Contents

Examples

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

Back to Contents