Check SQL in QlikView

Question

Is it possible to see the SQL QlikView generates when accessing the data in a database? (Something like in BusinessObjects "Show Script" option). If yes, where can I find it?

Answer 1

In the QVW file where the SQL exists, go to the document properties: Settings -> Document Properties -> General - check the 'Generate Logfile' checkbox. On the next reload, a log file will now be created in the same folder as the QVW with a .log extension. So if your QVW is called abc.qvw, there will be a log file called abc.qvw.log in the same folder. In this log file, the SQL which is passed to the database will be logged (this will be the sql after any dynamic elements have been evaluated - e.g. any dynamic variables which might be injected into the where clause).