Discussion Board for collaboration on QlikView Publisher.
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.
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...