Loading SQL query into qlik sense

[#1]

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.

[jayaseelan]

Hi marco,

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

[#3]

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

[andrespa]

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]

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]

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