order by doesn't work

[#1]

Hi!

if i do

load time,number

resident table

order by time;

(time is numeric)

my table doesn't order by time but it is oder randomly.

[Sokkorn]

Hi Davide,

I really don't get your point, but maybe you need to view order in table viewer. If so then we ask this question:

1. Why I need to view order in table viewer?

2. If I can sort order in table viewer, what is the benefit for developer? What is extra load time and process when use order by?

3. Our customer need to sort order in table viewer or in QlikView object (Straight Table, Pivot Table,...)?

So from my idea is do not sort order in load script. I prefer sort order in QlikView object.

Regards,

Sokkorn Cheav

[#3]

hi sokkorn,

I need to order the table on load statement because I need to use fieldindex() and this function works on load order.

[Tyler_Waterfall]

I know this is quite an old post, but I am also not able to get the ORDER BY to work (11.20) in the load script when used as described in the help (resident load, etc.)

[swuehl]

Tyler,

I would suggest that you open a new thread.

Please add as many information as possible (best using a small sample app that demonstrates your issue).