topic Re: preceding load in QlikView

preceding load

Thu, 08 May 2014 10:10:06 GMT

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

alexandros17 — Thu, 08 May 2014 10:13:25 GMT

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 — Thu, 08 May 2014 10:15:55 GMT

HI,

Plz refer to following link.

Regards,

Nirav Bhimani

Thu, 08 May 2014 11:03:26 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.

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