Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a JSP file which Extracts the SQL query used inside a web intelligence report and gives the output as an SQL query.
Now i want to pass this SQL query as the source in the Editor of the QlikView dashboard that i am creating .
Everytime Qlikview should run the JSP dynamically and get the SQL output of the JSP file as the datasource for the Dashboard.
Please let me know if there are any possible ways to achieve it since I am new to Qlikview
Thanks !!
You can't. The SQL editor is for database sources, not file sources. Use the File Wizard instead and choose the option Web Files.