Skip to main content

Document Properties: Sort

On this property tab the sort order for the values of any field in the document can be configured. The sort order of a field can also be set from the Sort tab of the Properties dialog for different sheet objects.

Select a field in the Fields list to the left, then check one or more of the options to the right. The options are described below.

In the Sort by group the default sort order of the field values in the sheet objects can be set. Changes made in this group will affect fields in sheet objects created after the change. Previously created sheet objects will not be affected.

Document Sort properties
Property Description
State Toggles the status whether the sorting procedure of values should be made by selection state. The selected values appear at the top of the list if this option is set. The sort order is: selected, possible, excluded (ascending).
Expression Field values will be sorted according to an arbitrary expression that is entered into the text edit box below this sort option.
Frequency Toggles the status whether the sorting procedure of values should be made by frequency.
Numeric Value Toggles the status whether the sorting procedure of values should be made by numeric value.
Text Toggles the status whether the sorting procedure of values should be made in alphabetical order according to the ASCII standard.
Load Order Toggles the status whether the sorting procedure of values should be made in load order.

The Reset button sort order is sort by state, ascending and sort by Text, A --> Z.

If more than one sort order is specified the sort order will be state, expression, frequency, numeric, text, load order.

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 – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com