Load a random sampling data set for Data Profiling in QlikView

QlikView_Load_Sampling_Data.qvs

// In this case we want to load a 10% sampling set of the data
// The QlikView way:
data:
Sample(0.1) LOAD <your fields>
FROM <your source file>
 
// My way, using random function:
data:
LOAD <your fields>
FROM <your source file>
WHERE ceil(rand() * 100) <= 10;
 
// My tests showed that the resulting amount of sample rows were more accurate with random function,
// but mostly 10-20% higher than expected with QlikView sampling.