Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.)