Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Fetching data using SQL Query

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Create a SQL Database link in QV script.

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

It should work.

View solution in original post

5 Replies
MK_QSL
MVP
MVP

Create a SQL Database link in QV script.

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

It should work.

Anonymous
Not applicable
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Hello Anil

You are saying regarding the connection to database right?

Regards

Chintan

Anil_Babu_Samineni

Yes

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)