PL/SQL CODE TO MODIFIED TO QLIK VIEW SCRIPT

[#1]

Hi,

Below is the code that i need to excecute in qlik view script but i am not able do this can any one give solution to this

select def.reg_id, def.name as report_name, var.name as region, status_id, count(*)
from definition def, instance ins , variation var
where def.name like '%F%O%' and is_active =1
and def.reg_id = var.reg_id
and def.reg_id = ins.reg_id
and ins.DATE = '9 MAR 2011'
and upper(var.name) ='IND'
and upper(template_name) not like '%NOTINDIA%'
and upper(template_name) not like '%NOTUSA%'
group by def.reg_id, def.name, var.name , status_id
order by def.reg_id, status_id

And any one brief about the calling package in qlik view script please.

Thanks,

Uday V

[Oleg_Troyansky]

You should be able to execute it in QlikView, by adding a prefix SQL before Select and finishing he sentence with a semi-colon. If this syntax is valid on your DB platform, it should be equally valid in QlikView

[#3]

it's bad advace, but best option for me, do it query in other program, MS SQL SERVER for example, i always create complex VIEW and then export it to Excel,then from in qlikview just import .xls-file.

if you use connection to database - just create View with your query.

Maybe qlikview know what is "inner join"

if you load table t1 and t2 with field t1.id and t2.id - qlikview will create syn_table.

You can load 3 tables, field reg_id is same for all tables, then for each table write WHERE, then in graph or tables just make COUNT.

... or just create view.)