topic Re: SQL Scripting in QlikView

SQL Scripting

Mon, 03 Dec 2012 15:04:14 GMT

Hello Community members,

I have doubt regarding SQL scripting, can we develop total project using the sql commands and scripting in qlikview. If any one had developed the project, please post a sample sheet for me

Re: SQL Scripting

Gysbert_Wassenaar — Mon, 03 Dec 2012 15:48:35 GMT

Qlikview itself doesn't understand sql. Qlikview simply passes any sql statement (anything starting with SQL or SELECT) to the dbms for execution and treats the returned results as a table. So you can put any sql statement in your script in your Qlikview document. As long as it's a valid sql statement for your dbms it should return results. Two examples:

// simply load everything from mytable into a table called Table1

Table1:

select * from mytable;

//first load a,b and c from myothertable, then load a and b+c as d into Table2

//this is called a preceding load and can be used to process the data (with qlikview functions) from the sql statement

Table2:

load a, b+c as d;

select a,b,c from myothertable;

Re: SQL Scripting

Mon, 03 Dec 2012 16:52:08 GMT

Thanks for your response Gysber,,

So, Internally, their will be sql execution engine for the execution of sql queries, if so can we write sql functions like date functions,upper etc ?.

Regards

ramesh

Re: SQL Scripting

shree909 — Mon, 03 Dec 2012 16:54:52 GMT

Yes u can write the upper and date functions same way as u do in sql..

Re: SQL Scripting

MayilVahanan — Mon, 03 Dec 2012 16:55:50 GMT

Yes. You can use sql queries in qv n exceute. For better performance, Load the data in qvd , to avoid connection each time to sql engine

Re: SQL Scripting

Mon, 03 Dec 2012 17:14:51 GMT

Thanks all of you for your great response

Regards,

Ramesh