If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Can some one help me to find out why Order By is not working with following syntax:
order by Date desc;
copied from here
Does order by not work in the load script? | Qlik Community
View solution in original post
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).