New to Qlik Sense

[Anonymous]

Hello Qlikers,

Can some one help me to find out why Order By is not working with following syntax:

Load distinct

Date

resident Table

order by Date desc;

Regards,

Balraj

[Chanty4u]

Hi

ORDER BY in a LOAD statement can be used with RESIDENT tables.

If your source itselfs supports an order by (most common example: a SELECT ... FROM ... ORDER BY....;) you can use this as well (note that the sorting is performed by the source DBMS, not QV).

Also note, that QV's ORDER BY is sorting the input table, not the ouput table (so won't result in a sorted table e.g. when using a LOAD DISTINCT).

[Chanty4u · Accepted solution]

copied from here

Does order by not work in the load script? | Qlik Community