Can i get data from any SQL query into qvw

[rsdhavle]

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

[#2]

Hi Rohan

You can load your SQL query in QVW

Eg:

SQL

Select * from Employee;

[rsdhavle]

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.

[arulsettu]

hi

you have to use replace like this

Ex:

replace load * from employee;

[#5]

May I know what type of error you are faced?

[#6]

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

[MK_QSL]

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

[jagan]

Hi,

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

Regards,

Jagan.

[rsdhavle]

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?

[#10]

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.