Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guise can any one help me I want to see the SQL query being generated in QlikView Please tell me how can I find that.
Regards
Surbhi Sahu
Bisp Solutions Inc
Do you mean that you want to create SQL Querys in QlikView? If you are looking for a wizard you won't find anything like it since QlikView is not a Database client, but you can code (type or copy) almost any SQL Query in the script. Just remember to place the Connection String before the query's.
Hi Surbhi,
If you are using Microsoft SQL Server I would recommend you start SQL Profiler and trace the query coming in from QlikView.
If you're not using MS SQL then use whatever tool comes with the database you are using.
Regards,
Clint Carr
No I am not talking about the self written query I am want the auto,automatically generated sql queries by QlikView,in background when we reload the dashboard. But thanks for the replay.
Regards
Surbhi Sahu
Bisp Solutions Inc
Hey Clint
Actually this is the way but If I need the queries/script when my dashboard will perform calculation according to expression given.Do you have any idea for this?
Regards
Surbhi Sahu
Bisp Solutions Inc
Hi,
QlikView doesn't use SQL, so if you are after the query that QlikView uses to the in memory model I am not sure there is anything.
If what you are actually after is methods to performance tune your applications then I would recommend the following:
1. Governance Dashboard
2. http://robwunderlich.com/downloads (look at the document analyser)
3. QlikView System Monitor
Regards,
Clint