topic Re: Benefit of using Preceding load .. in QlikView

Benefit of using Preceding load ..

Wed, 24 Jul 2013 10:36:36 GMT

Can someone help me with simple example to understand how to use preceding load and the advantage of using it ??

I've already gone through few of the blogs but the advantages have not been clearly called out..

What is preceding load ?? with example

How to use it ??

What is the advantage of using it ?

Re: Benefit of using Preceding load ..

pennetzdorfer — Wed, 24 Jul 2013 10:41:09 GMT

There are two useful blog posts:

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

http://qlikviewnotes.blogspot.co.at/2009/12/simplify-with-preceeding-load.html

Regards,

Florian

Re: Benefit of using Preceding load ..

Wed, 24 Jul 2013 11:32:35 GMT

Thanks Mohit ,

From your example., I can use the Month(Date) in the Normal load itself if I use this in the Preceding load will that improve the performance ??/

Re: Benefit of using Preceding load ..

Wed, 24 Jul 2013 11:49:51 GMT

Definition of Preceding load--

if you have a table and suppose there are 10 field in this table,

now if you want to work on some fields of this table then you can use preceding load.

hope this helps you for understanding the Preceding load

Re: Benefit of using Preceding load ..

Wed, 24 Jul 2013 12:01:42 GMT

I understood what is preceding load is all about.

But how this is helpful if I use the below

LOAD //This section is called preceding load

Month(Date) AS Month,

Year(Date) AS Year;

LOAD // Normal load.

Department,

Date,

Sales

FROM DataSource;

Just happened to refer Henrick's

QlikView will start from the bottom and pipe record by record to the closest preceding Load, then to the next, etc. And it is always faster than running a second pass through the same table.

Why QV has to pipe the records one by one to the closest preceding load ?? In this case additional load on the memory ?? In the single pass itself can't we do the transformation while loading the data using the LOAD statement (Normal Load) ??/

Re: Benefit of using Preceding load ..

er_mohit — Wed, 24 Jul 2013 12:11:51 GMT

In normal load for some aggregation function like min, max, sum we can't use this function directly in load

so use of precedence load to calculate some field for max and min with group by we use precedence load

and if you do something in normal load with condition like

load A,max( [Above 1000 C]) as Max

group by A;

load A,

if(C>1000,C) as [Above 1000 C]

from datasource;

so it only figure out with field A and getting the max value of [Above 1000 C] on the basis of A field so you can do this

Have a look this Script and Reload it on your desktop

test1:

LOAD C,max(Multiply)as Max

Group by C;

LOAD A*B as Multiply, * INLINE [

A, B,C

1, 1,SD

2, 2,WE

3, 3,SD

4, 4,QW

5, 5,QW

6, 5,WE

];

hope it helps

Re: Benefit of using Preceding load ..

Wed, 24 Jul 2013 12:27:18 GMT

Thanks Mohit and the rest.

Re: Benefit of using Preceding load ..

stevedark — Thu, 20 Nov 2014 01:22:37 GMT

You may want to take a look at this post on preceding loads?

http://www.quickintelligence.co.uk/preceding-load-qlikview/

Steve