Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

I want to see the SQL query being generated in QlikView

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

5 Replies
carlos_reyes_qv
Valued Contributor

Re: I want to see the SQL query being generated in QlikView

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.

Employee
Employee

Re: I want to see the SQL query being generated in QlikView

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

Not applicable

Re: I want to see the SQL query being generated in QlikView

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

Not applicable

Re: I want to see the SQL query being generated in QlikView

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

Employee
Employee

Re: I want to see the SQL query being generated in QlikView

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