Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Do you why we need to have a load statement in front of the SQL Statement.

Hi All,

Can anyoine tell me what is the difference between the following two statements:

Script A

[Qlikview_A]:

Load

     Column_1,

     Column_2;

Sql

     Select

          Column_1,

          Coilumn_2

     from

          Table1;

Script B

[Qlikview_B]:

Sql

     Select

          Column_1,

          Coilumn_2

     from

          Table1;

Do you why we need to have a load statement in front of the SQL Statement?

Thanks!

Elim

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

5 Replies
Highlighted

AFAIK I don't think you do. Even with your Script B, you should see the same result as Script A.

Highlighted
MVP & Luminary
MVP & Luminary

Highlighted

Hi Elim,

We can do some aggregations in load statement itself

for your reference

What is preceding load in qlikview?

Highlighted

>>Can anyoine tell me what is the difference between the following two statements:

None whatsoever.

You only need a LOAD in front of the SQL SELECT (a preceeding load) if you need to apply some transformations using QV functions, or if you want to limit the number of fields you load from a stored proc (with SQL EXEC). Otherwise it is not necessary.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Not applicable

Got it!

Thanks for the input from everyone. Now I understand  why we have to use the load statement b4 the SQL statment. I normally need not to use it unless I need to some transformations.

Thanks!

Elim