topic Re: Ordering & Resident in QlikView https://community.qlik.com/t5/QlikView/Ordering-Resident/m-p/688828#M474007 <HTML><HEAD></HEAD><BODY><P>1. You can't use <STRONG>Order By </STRONG>without using resident load.</P><P></P><P>2. If your source data is already sorted you don't need further order by clause, qv will load data row by row.</P></BODY></HTML> Thu, 09 Oct 2014 08:41:26 GMT senpradip007 2014-10-09T08:41:26Z Ordering & Resident https://community.qlik.com/t5/QlikView/Ordering-Resident/m-p/688827#M474006 <HTML><HEAD></HEAD><BODY><P>Good morning All,</P><P></P><P>2 quick questions.</P><P></P><P>1) Is there any other way to order my data say in date order without using a resident load?</P><P>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?</P><P></P><P>Thank you</P><P></P><P>H</P></BODY></HTML> Thu, 09 Oct 2014 08:28:55 GMT https://community.qlik.com/t5/QlikView/Ordering-Resident/m-p/688827#M474006 2014-10-09T08:28:55Z Re: Ordering & Resident https://community.qlik.com/t5/QlikView/Ordering-Resident/m-p/688828#M474007 <HTML><HEAD></HEAD><BODY><P>1. You can't use <STRONG>Order By </STRONG>without using resident load.</P><P></P><P>2. If your source data is already sorted you don't need further order by clause, qv will load data row by row.</P></BODY></HTML> Thu, 09 Oct 2014 08:41:26 GMT https://community.qlik.com/t5/QlikView/Ordering-Resident/m-p/688828#M474007 senpradip007 2014-10-09T08:41:26Z Re: Ordering & Resident https://community.qlik.com/t5/QlikView/Ordering-Resident/m-p/688829#M474008 <HTML><HEAD></HEAD><BODY><P>Thank you</P></BODY></HTML> Thu, 09 Oct 2014 08:54:38 GMT https://community.qlik.com/t5/QlikView/Ordering-Resident/m-p/688829#M474008 2014-10-09T08:54:38Z