Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
balrajahlawat
Champion
Champion

Order by at script not working

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

1 Solution

Accepted Solutions
2 Replies
Chanty4u
Champion III
Champion III

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).