preceding load

[#1]

hi

     i am new in qlikView .what is the use of preceding load of relational database table in qlikView.

[alexandros17]

If you mean something like this:

Load

     *;

Select * from myTable;

This type of loading is used to apply Qlik functions to the data loading, infact if I want to use for example Num() function

I can write :

Load

     *, Num(myField) as newField;

Select * from myTable;

[nirav_bhimani]

HI,

Plz refer to following link.

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

Preceding load

Regards,

Nirav Bhimani

[#4]

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.

while fetching data from database will find this option as attached image.