- Open Qlik Sense App and click your app from the hub to launch it.
- Go to Prepare from the top menu, then open the Data Load Editor.
- Click Create new connection and select your database type (for example, ODBC or SQL Server), then enter your connection details and save it.
- In the editor, select your connection and insert a SELECT statement to query your data (for example, SELECT * FROM NEPS_table).
- Click Load data to run the SQL query and import the results into your app.
- After the load completes, open the Data Model Viewer to confirm the queried data appears as a table.
How to Run SQL Query in Qlik Sense
📌 Why this matters
Why this matters
Running SQL queries in Qlik Sense gives you direct control over how data is retrieved from your database, which is essential for working with large or complex datasets. Instead of loading entire tables, you can filter, join, and shape the data before it even enters your app, improving performance and clarity. This approach is especially useful for teams working with structured databases where precision matters. By combining SQL with Qlik Sense’s in-memory engine, you can build faster and more efficient analytics workflows.
Your product deserves an interactive demo
