Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

loading a sample set of data

Does anyone know if there is a command that would allow me to load just a sample set of data?

1 Solution

Accepted Solutions
MVP
MVP

loading a sample set of data

Hello,

Depending on how is your data source strctured, it could be as easy as doing something like

SampleTable:LOAD Field1, Field2, RecNo() WHERE RecNo() <= 100; SQL SELECT Field1, Field2 FROM DataSource;


Another option is to create a table loading just the dates existing on your data source, and then loading, with a very similar code, some records for each date.

1 Reply
MVP
MVP

loading a sample set of data

Hello,

Depending on how is your data source strctured, it could be as easy as doing something like

SampleTable:LOAD Field1, Field2, RecNo() WHERE RecNo() <= 100; SQL SELECT Field1, Field2 FROM DataSource;


Another option is to create a table loading just the dates existing on your data source, and then loading, with a very similar code, some records for each date.

Community Browser