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?
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答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).
