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
 
					
				
		
 Carlos_Reyes
		
			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.
 
					
				
		
.png) Clint_Carr
		
			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
 
					
				
		
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
 
					
				
		
.png) Clint_Carr
		
			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
