Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
2 Replies
Chanty4u
MVP
MVP

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