Vizlib Home Try Vizlib
Welcome
Login

Vizlib Table Properties - Data - Measures, Representations and Minicharts

TABLE OF CONTENTS


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), you can set different colors and icons to display for values where Value>0, Value<0, and Value=0.


Figure 9: Indicators


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). Figure 12 shows the settings for a bar chart. You'll see the Minichart Dimension displayed, and you can choose to Use same start date. 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 12: Minichart


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 Chart

Bar Color, Negative Bar Color, Max. Amount of Bars, Show First 50 Bars, Bar Width, Bar Spacing, Zero Axis. 

Combo chartSettings for Line Chart and Bar Chart (see above). 
Pie chartColors (Scheme or comma separated Hex codes). 
Stacked bar chartMax. 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). 


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


M
Martin is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.