QlikView – Preceding Load

QlikView Preceding load is a load type in which we use a loaded statement, which takes the columns of another load statement present in the same script. The data is 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 screenshot 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 the group by clause.

Table Box Data

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

Leave a Reply