Vizlib Home Try Vizlib
Welcome
Login

Vizlib Sankey Chart Properties - Dimensions, Measures, Sorting, Data Handling

Vizlib Sankey Chart supports one measure with multiple dimensions. In the Data section, you can add dimensions or metrics dynamically and decide whether they should be used directly or added as alternative dimensions, which can be selected when you're in analysis mode. 


TABLE OF CONTENTS


Dimensions


When you add a dimension (Figure 1), you can choose to Include null values, and set a Limitation on your chart data, choosing from a Fixed number (e.g. the top 10 values), the Exact value, or a Relative value (e.g. only showing values above 50%). Show (Always / Conditional) gives you the ability to specify a conditional expression which shows or hides the dimension in the Sankey chart.

Node Color specifies a color for the dimension, and you can also specify the color using a HEX code in a Qlik expression. You can also display the dimension label by enabling Node Label and display the measure value for the dimension nodes with Node Value.


Figure 1: Dimensions 


Group Nodes (Figure 2) enables grouping to join multiple dimension values into groups. 


Figure 2: Group Nodes


Back to Contents


Measures


When you add a measure (Figure 2), there's a setting to enable Master measure formatting, which means formatting for the measure will be taken from the master item definition (you can find master items in the Custom Objects menu in the left hand panel). You can also choose to Use custom Pattern, select a Number formatting option, and enable Use currency to add currency formatting.  

Note: Master measure formatting is not displayed for measures created using the Fields list. 


Figure 3: Measures


Back to Contents


Sorting


The Sorting settings (Figure 4) allows you to enable a General sort by node size, and set it in Ascending or Descending order. 



Figure 4: Sorting


Back to Contents  


Data Handling


With Data Handling settings (Figure 5) you can set a Sankey Nodes Limit specifying the Max Nodes Per One Dimension, and set a Data Downloading limit (by default, this is limited to the first 5000 rows). You can also choose to Suppress Zero Values and set a Calculation Condition

to display the chart if a condition is met.  



Figure 5: Data Handling


Back to Contents 



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.