Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading a few sample data from database

Hi everybody,

Is there any way I can load only a few sample from a database?

I'm developing a project from a hudge database and don't want to wait a long time just to check if everything was ok.

Thanks,

Ronan

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Ronan

From the script editor, click the Debug button, and check the Limited Load check box and select the number of records in the box below.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

I often use
FIRST 1000 // or whatever number you want
LOAD
...

It makes sense to have a variable vFirst, and use it
$(vFirst)
before each big table load. Easy to change to nothing or to string like 'FIRST 1000'

Not applicable
Author

Thank you!