I want to see the SQL query being generated in QlikView

[#1]

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

http://bisptrainings.com

[Carlos_Reyes]

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.

[Clint_Carr]

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

[#4]

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

http://bisptrainings.com

[#5]

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

http://bisptrainings.com

[Clint_Carr]

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