Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading SQL query into qlik sense

Hi all

How do i load a SQL query into qlik sense? Not a table but a query.

The tables are going to be too big so i want to load a pre-defined query which gives me the data i want.

Please help.

5 Replies
jayaseelan
Creator III
Creator III

Hi marco,

 

            Please refer this link  Using the new Qlik Sense Desktop – Intelligent SQL.  i hope this will helps you.

Not applicable
Author

You are showing me how to load tables... i want to load a query

andrespa
Specialist
Specialist

Hi Marco, I think you can create a SP on your DB and the load it in QlikSense as you will normally load a table.

Hope it helps,

Andrés

Anonymous
Not applicable
Author

My take on this is create a Stored procedure and once you execute the stored procedure , it will store the result set for you. In qlik Sense or qlikview when you pull the information you can use select statement and you get the cached data from your stored procedure result set. Hope this helps you

Anonymous
Not applicable
Author

Hi Marco,

You can try creating a view with the query and then load the view into QlikSense via the load script. Here's a sample script used to load a view from sql server to qlik;

LOAD *

;

SQL SELECT *

FROM database.dbo.viewname;

Hope this helps