Levels always sorted alphabetically ascending

Sonja_Bauernfeind — Tue, 19 Jan 2021 12:07:10 GMT

NPrinting always sort levels alphabetically and ascending. Even when values of the dimension used as NPrinting level is loaded in a specific order, this load order is disregarded.

See Fig 1 as an example:

Fig 1

The level sorts alphabetically and ascending in the NPrinting report (Fig 2):

Fig 2

Cause:

This is working as designed. Accordingly, when you use a Qlik Sense field as an NPrinting Level, then the Level values will be sorted alphabetically and ascending disregarding the load order. This is due to how Qlik Sense exports field data.

Resolution:

If you want to retain load order in NPrinting level, you need to put the field into a table and import this table (instead of the field) as NPrinting level.

Add table into level instead of field, such as shown in Fig 3.

Fig 3

When that is done, the NPrinting report gets the correct order in the QlikSense app (Fig 4).

Fig 4

article Levels always sorted alphabetically ascending in Official Support Articles

Levels always sorted alphabetically ascending

Cause:

Resolution: