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

 

 

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?