Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one tell me Is there any sql queries generated while reloading the dashboard in QlikView if yes so how can I get that.Please any one give me the answer.
Regards
Surbhi Sahu
Bisp Solutions Inc
Go to Settings > Document Properties > check Generate Logfile ... then load Qlikview ... you can see a notepad is create in the path, where you can go thought the script .. You can check that script in the qlikview with Ctrl + E
When QlikView reloads data, it just executes the script. No other queries are generated.
However, if you use Direct Discovery by defining a "DIRECT SELECT" in the script, individual charts in QlikView may generate SQL queries. See more on http://community.qlik.com/blogs/theqlikviewblog/2012/10/19/self-service-big-data-analysis-with-qlikv...
HIC