topic What is difference between select and load in QlikView https://community.qlik.com/t5/QlikView/What-is-difference-between-select-and-load/m-p/490316#M183136 <HTML><HEAD></HEAD><BODY><P>What is difference between select and load</P></BODY></HTML> Thu, 09 Jan 2014 14:58:54 GMT 2014-01-09T14:58:54Z What is difference between select and load https://community.qlik.com/t5/QlikView/What-is-difference-between-select-and-load/m-p/490316#M183136 <HTML><HEAD></HEAD><BODY><P>What is difference between select and load</P></BODY></HTML> Thu, 09 Jan 2014 14:58:54 GMT https://community.qlik.com/t5/QlikView/What-is-difference-between-select-and-load/m-p/490316#M183136 2014-01-09T14:58:54Z Re: What is difference between select and load https://community.qlik.com/t5/QlikView/What-is-difference-between-select-and-load/m-p/490317#M183137 <HTML><HEAD></HEAD><BODY><P>I believe the biggest difference is that a SELECT statement retrieves from the database and the LOAD statement has to do with how it is loaded into QV's memory.&nbsp; I am sure there is more to it.</P></BODY></HTML> Thu, 09 Jan 2014 15:10:41 GMT https://community.qlik.com/t5/QlikView/What-is-difference-between-select-and-load/m-p/490317#M183137 2014-01-09T15:10:41Z Re: What is difference between select and load https://community.qlik.com/t5/QlikView/What-is-difference-between-select-and-load/m-p/490318#M183138 <HTML><HEAD></HEAD><BODY><P>Hi anil,</P><P></P><P>SELECT is used to draw data from a database.</P><P>LOAD is usually used to load from a qvd, from an Excel - anything except a database, actually</P><P>&lt;=&gt; You can, and should probably, use a LOAD on top of a SELECT when you load data from a database (because some functions might be available in QlikView which are not part of the SQL syntax and v.v.).</P><P></P><P>HTH</P><P></P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Thu, 09 Jan 2014 15:11:02 GMT https://community.qlik.com/t5/QlikView/What-is-difference-between-select-and-load/m-p/490318#M183138 datanibbler 2014-01-09T15:11:02Z