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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Devid
Contributor
Contributor

Basics - Loading DB Data

I am new to using Qlik Sense.

Loaded data from database into Qlik app successfully.

But database has a table with millions of records. Takes a long time to load, sometimes crashes.

I need to to load just a few hundred records from that specific table in the database to work on the app easilly.

How do I do that?

Thank you.

Labels (1)
1 Reply
MartW
Partner - Specialist
Partner - Specialist

if you ware loading data from a database you can try Select TOP {amount-you-want-to-load} FROM ...

if you are loading in a QVD or QVX you can use the function First