Skip to main content Skip to complementary content


The First prefix to a LOAD or SELECT (SQL) statement is used for loading a set maximum number of records from a data source table.


First n ( loadstatement | selectstatement )


First arguments
Argument Description

An arbitrary expression that evaluates to an integer indicating the maximum number of records to be read.

n can be enclosed in parentheses, like (n), but this is not required.


First 10 LOAD * from abc.csv;

First (1) SQL SELECT * from Orders;

Learn more


Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: