QlikView: "Order by" in load script

[marina24]

Hi,

Order By on a resident table doesn't work. Why? 

[TABLE]:
LOAD ID, AMOUNT
From [C:\Users\User\Desktop\test.xlsx]
(ooxml, embedded labels);

[final_TABLE]:
NoConcatenate
LOAD ID, AMOUNT
Resident TABLE
Order by AMOUNT desc;

DROP Table TABLE;

---

This script retuns:

[Taoufiq_Zarra · Accepted solution]

@marina24 

the order in the load script allows you to apply the order in the internal table of QLikview (preview)

in UI you can use :

[marina24]

Taoufiq_ZARRA, Thank you so much for your help.