Skip to main content Skip to complementary content


The sample prefix to a LOAD or SELECT statement is used for loading a random sample of records from the data source.


Sample  p ( loadstatement | selectstatement )


Sample arguments
Argument Description

An arbitrary expression which valuates to a number larger than 0 and lower or equal to 1. The number indicates the probability for a given record to be read.

All records will be read but only some of them will be loaded into QlikView.


Sample 0.15 SQL SELECT * from Longtable;

Sample(0.15) LOAD * from Longtab.csv;

Information note The parentheses are allowed but not required.

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: