QlikView properties: dimensions

Dimensions are in Chart.Dimension list. The first dimension is Chart.Dimension.0, the second dimension is in Chart.Dimension.1, and so on.

The following dimension properties can be defined:

Chart.Dimension.0.Field The field used for the dimension
Chart.Dimension.0.Label Label for the dimension
Chart.Dimension.0.Sort.PrimarySort.Use 1: Primary Sort Enabled
Chart.Dimension.0.Sort.PrimarySort

0: None

1: Y-Value

2: Frequency

3: Numeric Value

4: Text

5: Load Order

Chart.Dimension.0.Sort.PrimarySortOrder

1: Ascending

-1: Descending

Chart.Dimension.0.Sort.SecondarySort.Use 1: Secondary Sort Enabled
Chart.Dimension.0.Sort.SecondarySort

0: None

2: Frequency

3: Numeric Value

4: Text

5: Load Order

Chart.Dimension.0.Sort.SecondarySortOrder

1: Ascending

-1: Descending

Chart.Dimension.0.Sort.ByExpression.Use 1: Sort By Expression Enabled
Chart.Dimension.0.Sort.Expression Expression to sort by
Chart.Dimension.0.Sort.ByState.Use 1: Sort by state, that is keep selected on top.
Chart.Dimension.0.Column.RestrictShownValues 1: Limit the number of values shown.
Chart.Dimension.0.Column.OtherMode

1: OtherCountedMode

2: OtherLimitedSort

3: OtherAccumulatedSort

Chart.Dimension.0.Column.OtherCountedMode

Used for OtherMode 1.

0: First

1: Largest

2: Smallest

Chart.Dimension.0.Column.OtherCountedCount How many values should be shown.
Chart.Dimension.0.Column.OtherLimitedSort

Used for OtherMode 2

0: Greater Than or Equal To

1: Less Than or Equal To

2: Greater Than

3: Less Than

Chart.Dimension.0.Column.OtherLimitedLimit Value for the Limit
Chart.Dimension.0.Column.OtherLimitedMode

0: relative to the total

1: exact amount

Chart.Dimension.0.Column.OtherAccumulatedSort

Used for OtherMode 3

0: First values (in sort order)

1: Largest

2: Smallest

Chart.Dimension.0.Column.OtherAccumulatedMode

0: relative to the total

1: exact amount

Chart.Dimension.0.Column.OtherAccumulatedLimit Value for the Limit
Chart.Dimension.0.Column.OtherIncludeBoundary 1: Include boundary values
Chart.Dimension.0.Column.OtherShow 1: Show 'Other' value
Chart.Dimension.0.OtherString Other label
Chart.Dimension.0.Column.OtherCollapseInnerDimensions 1: Collapse inner dimensions
Chart.Dimension.0.Column.TotalShow 1: Show Total
Chart.Dimension.0.TotalString Totals label
Chart.Dimension.0.Column.OtherGlobalGrouping 1: Use global grouping
Chart.Dimension.0.SuppressNull 1: suppress null values
Chart.Dimension.0.ShowAll 1: show all values