Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create a SQL Database link in QV script.
Copy paste the same query from SQL to QV script and run..
It should work.
Create a SQL Database link in QV script.
Copy paste the same query from SQL to QV script and run..
It should work.
Dear Manish
Thanks for your reply.
By 'Create a SQL Database Link ' you mean creating a connection string right?.
Regards
Chintan
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
Hello Anil
You are saying regarding the connection to database right?
Regards
Chintan
Yes