Sorting in Text() formatted mixed value fields

000005509 |19/12/2014
Did this article help solve your issue?

   

Description

The behavior in QlikView regarding sorting of alphanumeric fields differs from for example Excel. Even explicitly loading a field as a string - using Text() - won't have any effect on the sorting, but using Text() in for example a list box will.

Cause

The reason behind this behavior is performance. Full ASCII sorting on long mixed strings is very resource heavy, and is therefore avoided in the document load. The option to use ASCII sorting is available on the object level if the resource usage is acceptable. 

Resolution

If the Text() variable is used on an object, QlikView will sort for example "13ZZ0" before "1ZZZ0" since the ASCII value of 3 comes before Z. If the text() variabel is not set, 1ZZZ0 will be sorted first since Qlikview will interpret it numerically as "1", and 13ZZ0 as "13".  

An explanation of alphanumerical sorting can be found here:  http://www.davekoelle.com/alphanum.html

Disclaimer

Access to this article is provided to you as part of your subscription to Qlik Maintenance. This article is deemed to be “Documentation” under the terms of the license agreement applicable to your Qlik software. All rights reserved © QlikTech International AB.

Use the quick links or the search bar on the front page for quick answers.

Selecting one or several business profiles ensures you get the most valid information presented to you.

A new self-service feature enables you to download a LEF or Request a control number with the click of a button.

A completely new element! Create and manage your Qlik environments for a great overview and to ease the case submission process. Add in your licenses and products and have a full view of your own environment setup.

Add stakeholders who should receive updates to the case. See the latest status of your case and if any actions are needed.

Submit your cases to us with ease using the new case logging wizard.

We would really appreciate your feedback which would help us improve the experience on the Support Portal. Please email us on SupportPortal@qlik.com