The Vizlib Pivot Table supports unlimited measures.
Add a measure.
Set a custom Measure Label.
You have the ability to specify and customize your number formatting options.
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.
Use the switch to show or hide the Measures.
Choose between Text and Icon Representation Types for your Measures.
For both Representation Types:
- Choose whether you want the Header Labels to be displayed vertically or horizontally.
- Display the measure value as plain text, HTML or URL.
- For URL - set the Label.
Define the font color of the measure values. You can use Qlik expressions here to dynamically style the font color.
Define the font size of the measure values. You can use Qlik expressions here to dynamically style the font size.
|Choose between left/ middle or right Horizontal Alignment.|
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.
Adds shadow effects to your label.
Define the background color of the measure values. You can use Qlik expressions here to dynamically style the background color.
Enable the cell borders of the measure values.
Define the border color of the measure values. You can use Qlik expressions here to dynamically style the background color.
Define the thickness of the borders (slider or by expression).
Set the additional padding distance.
|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).
For 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: