When you're working with the data in Vizlib Grid Chart, you can apply changes in the Data, Sorting and Data Handling settings.
TABLE OF CONTENTS
Data - Dimensions and Measures
The Data section contains settings for the dimensions and measures in the grid chart.
Vizlib Grid Chart supports two dimensions, one for the X Axis and one for the Y Axis (Figure 1). You can choose to Include null values, set a Limitation from the dropdown (you can choose between a a fixed number (e.g. top 10 values only), an exact value and a relative value (e.g. show the top 50% of results). You can also add alternative dimensions by clicking Add alternative. There's more information about alternative dimensions in the Best Practice article.
Figure 1: Dimensions
Vizlib Grid Chart also supports two measures (Figure 2), the first controls the color and the second is displayed as you hover over the grid chart. You can choose a Number formatting option, with options from Auto, Number, Money, Date, Duration, Custom and a Measure expression.
Figure 2: Measures
Sorting
The Sorting settings (Figure 3) allow you to customize the sort method used. You can Sort by expression, Sort numerically or Sort alphabetically, in Ascending or Descending order. You can find more information on sorting in Qlik Sense here.
Figure 3: Sorting
Data Handling
With Data Handling (Figure 4), you can choose to Include zero values, if you don't need them to be displayed, enter a Calculation condition which needs to be met for the grid chart to make any calculations.
Figure 4: Data Handling