Sample

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

Syntax:  

Sample  p ( loadstatement | selectstatement )

Arguments:  

Argument Description
p

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.

Example:  

Sample 0.15 SQL SELECT * from Longtable;

Sample(0.15) LOAD * from Longtab.csv;

Note: The parentheses are allowed but not required.

See also:

 

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?