Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

SQL statement Vs LOAD statement in Qlikview?

Hi All,

Which one is better way to use (SQL and LOAD) while extracting data from data base

Can you explain breifly difference between SQL and Load

Thanks in Advance,

Nihhal.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Yes, using Load on top of SQL should not be used if not doing any calculations or new fields, this will load the same data again.

Hope this helps you.

Regards,

Jagan.

View solution in original post

11 Replies
Highlighted
MVP & Luminary
MVP & Luminary

If you extract data from a database over odbc or oledb you must use the SQL keyword. The sql statement is sent to the database as-is. Qlikview does not and cannot parse sql statements. For all other sources, files, resident tables and preceding loads you use the LOAD keyword. Only in a LOAD statement can Qlikview functions be used. See this blog post for information about preceding loads.


talk is cheap, supply exceeds demand
Highlighted
Specialist II
Specialist II

Hi Gysbert, Thank you for reply

I want to know the difference between SQL and LOAD. for instance if i extract data from datasourece thorugh this script what should be result

SQL empid

       ename

       loc

from emp;

And through this script what should be result

Load

      *

SQL empid

        ename

        loc

from emp;

Please let me know difference

Regards,

Nihhal.

Highlighted
MVP & Luminary
MVP & Luminary

The first example could be a tiny bit faster since it doesn't use a preceding load. The end result is exactly the same since the preceding load in your second example doesn't do transformations or calculations.


talk is cheap, supply exceeds demand
Highlighted
Specialist II
Specialist II

LOAD stmt is loading data into Qlikview from DB and SQL stmt also loading data from DB both are same as per you am i correct?

Highlighted
Not applicable

SQL statement pulls the dat from DB , and LOAD statement works on top of that data , and performs operations that coded in load statement and stores the results in QlikView.

Highlighted
MVP & Luminary
MVP & Luminary

Hi Nihhal,

The Load statement on top of select statement is used to transform the retrieved data from database, it is not mandatory to use Load statement on top of select statement.  We will use when we are doing any calculations or arriving new fields like below

Load

      *,

Capitalize(ename) AS ename_Formatted,

     MonthName(date) AS MonthYear,

     Week(date) AS Week;

SQL empid

        ename

        loc,

date

from emp;

Here we are getting Month and week using Load statements, and converting the ename to title case. 

Hope this helps you.

Regards,

Jagan.

Highlighted
Specialist II
Specialist II

Hi,

Or are you referring Direct Discovery Differences between In-Memory Fields and Direct Discovery Fields with example.Thanks

HTH

André Gomes

Highlighted
Master
Master

Hi,

1.  Firstly SQL Statement is used to extract data from datasources and Saves into Qlikview memory. SQL SELECT Statement is executed by ODBC driver.

2.  Secondly use Load to save those records in QlikView(in memory), since QlikView will work with them without being connected to the datasource.

3. The Load Saves the extracted data from any DataSource(Ex: Inline Statement, SQL SELECT, Data Bases, CSV files, SAP queries, Excel files, Etc...) into QlikView in memory.

4.  LOAD is not mandatory, is highly recommendable. Actually, when you don't Use a LOAD statement, you can do an implicit load by just using SQL SELECT statement.

5.   LOAD is used to transformed or convert those records in a way how do you want them to be dealt, create new fields based on those you already have in your datasource, etc. which can be used in visualisation.

Check below Links:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load

http://community.qlik.com/message/259159#259159

http://community.qlik.com/message/29385#29385

http://community.qlik.com/thread/13682

http://community.qlik.com/message/156421#156421

Regards

Neetha

Highlighted
Specialist II
Specialist II

SQL, LOAD both are extract data, STORE command only with store the data. Am i right?

My question is what is the diff b/w SQL and LOAD.