topic Re: Can i get data from any SQL query into qvw in QlikView

Can i get data from any SQL query into qvw

rsdhavle — Thu, 30 Jan 2014 06:37:58 GMT

Hi,

Can i get data from any SQL query which runs in SQL into qvw or there are any limitations such as few keywords will not work etc??

I think its not recognising REPLACE and few other keywords while reloading data from SQL

Re: Can i get data from any SQL query into qvw

Thu, 30 Jan 2014 06:39:35 GMT

Hi Rohan

You can load your SQL query in QVW

Eg:

SQL

Select * from Employee;

Re: Can i get data from any SQL query into qvw

rsdhavle — Thu, 30 Jan 2014 06:42:17 GMT

HI Nirmal,

My query is that, any query which is executable on SQL server is recognised by Qlikview or there are any limitations as i was trying to get data from one of my SQL query but its throwing an error while loading it in qvw with above syntax.

Re: Can i get data from any SQL query into qvw

arulsettu — Thu, 30 Jan 2014 06:43:21 GMT

you have to use replace like this

Ex:

replace load * from employee;

Re: Can i get data from any SQL query into qvw

Thu, 30 Jan 2014 06:45:23 GMT

May I know what type of error you are faced?

Re: Can i get data from any SQL query into qvw

Thu, 30 Jan 2014 06:49:09 GMT

Hi,

As per my knowledge there are certain limitations while u use SELECT query in qlikview. Can you post some sample code.

I have faced issues while using dates in where condition.

-Shruti

Re: Can i get data from any SQL query into qvw

MK_QSL — Thu, 30 Jan 2014 06:59:12 GMT

We can use SQL Query into QlikView Script... Better way is to use always Preceding Load....

Re: Can i get data from any SQL query into qvw

jagan — Thu, 30 Jan 2014 06:59:38 GMT

Hi,

Can you post the query you are using? without that it is difficult to identify the issue.

Regards,

Jagan.

Re: Can i get data from any SQL query into qvw

rsdhavle — Thu, 30 Jan 2014 07:00:04 GMT

Hi Shruti,

I will share sample query in sometime. I was thinking in some other way if there are any limitations of keywords can we create SP and us it in qvw or it will also give error for those keywords?

Re: Can i get data from any SQL query into qvw

Thu, 30 Jan 2014 07:04:00 GMT

Qlikview does not execute the SQL queries. It throws those queries to your database engine(Based upon your ODBC connections) and query gets executed their. QVW only plays with result set of the query.

Re: Can i get data from any SQL query into qvw

Thu, 30 Jan 2014 07:05:29 GMT

Hi,

We can execute/trigger Stored procedure thru qlikview and get data.

-Shruti