Vizlib Home

Vizlib Pivot Table Properties - Dimensions


The Vizlib Pivot Table supports an unlimited number of dimensions.

Add a dimension.

  • Label

Set a custom Dimension Label. 

  • Include Null Values

Uncheck the box to suppress null values in the chart. 

  • Limitation

Set the Data Limits by: 

  • setting a fixed number( for example, you are only interested in the top 10 values)  
  • defining the exact value 
  • or defining relative value (for example, you only want to show the values above 50%)

  • 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.

  • Dimension Visibility

Use the switch to show or hide the Dimensions.

Dimension Position

Determine whether the dimension is positioned at the left or the top of the table structure.

For Rows Position:

  • Set custom Left Column Width (using the slider) or select Auto Mode

For Column Position:
  • Choose whether you want the Header Labels to be displayed vertically or horizontally. 
  • Set custom Header Row Height using slider or just set the switch to Auto Mode.

Dimension Styling

For both Dimension Positions:

  • Choose Top or Bottom Position of the Expand Button.

  • Background Color
    Determine the background color of the dimension values. You can use Qlik expressions here, but a valid expression will only return a single color code. Use Dynamic Styling to apply a colors base to dimension values. 

  • Font Color
    Determine the font color of the dimension values. You can use Qlik expressions here.

  • Tooltip 
If enabled, the tooltip appears when hovering over the dimension. A small "hover box" with information will be displayed. 
  • You can define the Custom Tooltip Content  by defining the Value. 
  • Choose the Tooltip Color (color picker or by expression).

  • Totals
Show or hide the totals for the particular dimensions, with the ability to rename Totals.
Dynamic Styling 

  • Dynamic Styling
Here you have the ability to apply dynamic styling for individual dimension values. By specifying the dimension values (each being separated by a comma) you can style specific individual lines differently. 

dynamic styling example:

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.