Fetching data using SQL Query

[Anonymous]

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 · Accepted solution]

Create a SQL Database link in QV script.

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

It should work.

[Anonymous]

Dear Manish

Thanks for your reply.

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

Regards

Chintan

[Anil_Babu_Samineni]

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]

Hello Anil

You are saying regarding the connection to database right?

Regards

Chintan

[Anil_Babu_Samineni]

Yes