Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
marina24
Contributor III
Contributor III

QlikView: "Order by" in load script

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:

 

3.png

1 Solution

Accepted Solutions
Taoufiq_Zarra

@marina24 

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

Capture.PNGCapture.PNG

in UI you can use :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@marina24 

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

Capture.PNGCapture.PNG

in UI you can use :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
marina24
Contributor III
Contributor III
Author

Taoufiq_ZARRA, Thank you so much for your help.