Ordering & Resident

[#1]

Good morning All,

2 quick questions.

1) Is there any other way to order my data say in date order without using a resident load?

2) How does qlikview natural load data from a database, say from an Excel spreadsheet, does it go row by row from say row number 1, meaning that if the data is already sorted from the source they may not be a need to order?

Thank you

H

[senpradip007 · Accepted solution]

1. You can't use Order By without using resident load.

2. If your source data is already sorted you don't need further order by clause, qv will load data row by row.

[#3]

Thank you