Setting the default sort order

The sort order of a field will usually default to numeric or text order. Sometimes, this is not what we want because neither may be appropriate for a particular field. We can use a custom sort based on an expression but that adds an additional overhead to the frontend.

The most performant sort is the Load Order sort option. However, we cannot always rely on the order in which that data may have been loaded.

In this recipe, we will show how we can default that sort order.

Getting ready

Load the following script:

Data:
LOAD * INLINE [
  Country, Rank
  France, Low
  Ireland, Low
  Germany, High
  USA, High
  UK, Med
  Japan, Med
];

How to do it...

Follow these steps to set a default sort order:

  1. Add a listbox for Country and one for Rank ...

Get QlikView for Developers Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.