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:

Dimension properties that can be defined
Property syntax	Property function and values
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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here

QlikView properties: dimensions

Did this page help you?

Join the Analytics Modernization Program