Measures
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. |
Representation Type | Choose between Text, Indicator or Progress Representation Types for your Measures. |
For all the Representation Types:
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:
![]() | 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. ![]() |
![]() | Rounded corners Make the border square or rounded ![]() ![]() |
![]() | Vertical axis Enable the starting line for progress bars ![]() ![]() |
![]() | Show values Hide the numbers on the bar ![]() ![]() |
*Progress Bar Auto Scaling is only available when Indent Mode is disabled
example of the Vizlib Pivot table with the Progress bar