Vizlib Community

Submit a ticket Sign in
Welcome
Login

Vizlib Pivot Table - Measures

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 and Icon Representation Types for your Measures.

For both 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).

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:




V
Vizlib 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.