Vizlib Pivot Table Properties - Measures

Vizlib Team

Modified on: Tue, 8 Dec, 2020 at 4:00 PM

Measures

The Vizlib Pivot Table supports unlimited measures.

	Add a measure. Label Set a custom Measure Label.
	Number Formatting You have the ability to specify and customize your number formatting options.
	Calculation Condition Determines whether or not the dimension is included in the Vizlib Pivot Table (excludes the Dimension from calculation when the condition is 0). You can use Qlik expressions here.
	Measure Visibility Use the switch to show or hide the Measures.

Representation Type

Choose between Text, Indicator or Progress Representation Types for your Measures.

For all the Representation Types:

	Choose whether you want the Header Labels to be displayed vertically or horizontally.
Styling:	Display the measure value as plain text, HTML or URL. For URL - set the Label.
	Font Color Define the font color of the measure values. You can use Qlik expressions here to dynamically style the font color.
	Font Size Define the font size of the measure values. You can use Qlik expressions here to dynamically style the font size.
	Font Alignment Choose between left/ middle or right Horizontal Alignment.
	Font Style Define the font style of the measure values. Alternatively, change the style of the cells dynamically and when the evaluation expression returns 1 (or > 0) the style will be applied. Drop Shadow Adds shadow effects to your label.
	Background Color Define the background color of the measure values. You can use Qlik expressions here to dynamically style the background color.
	Borders Enable the cell borders of the measure values. Border color Define the border color of the measure values. You can use Qlik expressions here to dynamically style the background color. Border Size Define the thickness of the borders (slider or by expression). Additional Padding Set the additional padding distance.
	Tooltip If enabled, the tooltip appears when hovering over the measure. A small "hover box" with information will be displayed. You can customize the Tooltip Content by defining the Value. Choose the Tooltip Color (color picker or by expression).

Indicators Representation:

Set a threshold (supports Qlik Expressions) against which each measure value is benchmarked.

If the measure value is greater than the threshold, then the first icon is displayed.

If the measure value is less than the threshold, then the second icon is displayed.

If they are equal, then the third icon is displayed.

You can also define your icons based on expressions, e.g., use more than three icons.

measure indicators example:

Progress bar

The progress bar representation type automatically shows a visual representation of your measures directly inside a Vizlib Pivot Table.

	Bar Scale Define the min and max Value or set an Auto mode.
	Bar colours Choose the progress bar colour by colour-picker or use the standard Qlik expression.
	Negative Bar Enable the progress bar for negative values if needed. Define the colour.