QlikView - Preceding Load


Advertisements

QlikView Preceding load is a load type in which we use a load statement, which takes the columns of another load statement present in the same script. The data read by the first Load statement, which is at the bottom of the script editor window and then used by the load statements above it.

Load Script

The below given screen shot shows the script for data, which is loaded as Inline data and then the max function is applied to one of the columns. The load statement at the bottom makes the data available in QlikView's memory, which is used by the second load statement above the first load statement. The second load statement applies the max function with group by clause.

1_preceeding_load_script

Table Box Data

On creating a Table Box Sheet Object, we see the data that is read from the Inline data load option.

2_preceeding_load_table_box
Advertisements