topic Re: Fetching data using SQL Query in QlikView

Fetching data using SQL Query

Anonymous — Mon, 03 Apr 2017 08:09:07 GMT

Dear Friends

I have a SQL query wherein multiple tables are joined and multiple functions used.

Is it possible to use the same query and run in a Qlikview qvw using the syntax SQL Select to fetch the data?

Kindly share your comments if someone has used sql query in qlikview script and fetched the data.

Thanks & Regards

Chintan

MK_QSL — Mon, 03 Apr 2017 08:13:47 GMT

Create a SQL Database link in QV script.

Copy paste the same query from SQL to QV script and run..

It should work.

Anonymous — Mon, 03 Apr 2017 10:04:58 GMT

Dear Manish

Thanks for your reply.

By 'Create a SQL Database Link ' you mean creating a connection string right?.

Regards

Chintan

Anil_Babu_Samineni — Mon, 03 Apr 2017 10:08:25 GMT

We have 2 options over here

1) We can use direct SQL queries with in Qlik(has that capture)

2) May be ODBC and then connect then work on Qlikview script instead of third-party

Anonymous — Mon, 03 Apr 2017 10:16:46 GMT

Hello Anil

You are saying regarding the connection to database right?

Regards

Chintan

Anil_Babu_Samineni — Mon, 03 Apr 2017 10:25:39 GMT

Yes