topic DB SQL inside QV script in QlikView

DB SQL inside QV script

Wed, 06 Aug 2014 16:08:02 GMT

HI,

I am having new and interesting requirement.

"Select * from msd.emp where empid>10 " this is the sql and i want to use the same sql in Qlikview Script editor.

Instead of fetching the table how to use this SQL script inside the Qlikview Script editor??

Re: DB SQL inside QV script

Wed, 06 Aug 2014 16:15:12 GMT

Hi,

you can do this :

NAMEOFTABLE:

LOAD ID AS [FIELD], ...

SQL SELECT ID,... FROM Table;

Regards;

Benjamin

Re: DB SQL inside QV script

jaimeaguilar — Wed, 06 Aug 2014 16:16:27 GMT

Hi,

Within QlikView, you can combine SQL script with QlikView Script. A typical script combining both kinds of script would be like this:

Table:

Load *; //1

SQL Select * from msd.emp where empid>10; //2

//1. This is called preceding load. this part is what qlikview does after receiving the SQL script. Here you can either fetch the same data or narrow your extraction

//2. THE SQL statement indicates that everything after this will be sent to the database and therefore executed there. The final result wil be received by QlikView where you can manage it depending on your needs.

so this script executes from bottom to top,

regards

Re: DB SQL inside QV script

maxgro — Wed, 06 Aug 2014 16:36:40 GMT

just add the name of qlikview table and the sql prefix to your statement in the script editor

qlikviewtable:

sql

Select * from msd.emp where empid>10

;

Re: DB SQL inside QV script

Thu, 07 Aug 2014 01:32:49 GMT

Massimo Grossi,

Thanks for your reply and it works absolutely fine.