TABLE OF CONTENTS
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, Indicator or Progress Representation Types for your Measures.
For all the Representation Types:
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:
Define the min and max Value or set an Auto mode.
Choose the progress bar colour by colour-picker or use the standard Qlik expression.
Enable the progress bar for negative values if needed. Define the colour.
Make the border square or rounded
|Vertical axis |
Enable the starting line for progress bars
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