Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

qlikview script for the SQL.

Hi All,

I am trying to convert below sql to Qlikview terms.

While fetching sourceOrderNumber in qlikview terms, should i use inner join. If so there are three tables, in which order should i load in qlikview.

select r.request_id,

          (select rpv.value_string from icareprd_cid_admin.request_param rp, icareprd_cid_admin.request_param_value rpv where rp.request_id = r.request_id and rp.param_id = 1144 and rp.value_id = rpv.value_id) as sourceOrderNumber,

          r.request_creation_date as orderDate

          from icareprd_cid_admin.request r

Please give me some idea to proceed..

4 Replies
its_anandrjs

Hi,

I suggest you to use joins to get connected this tables and by the help of where clause like you use in SQL query or load the all tables and then create a resident table of that one like with the help of Where clause

And join the tables with your where condition like

Table1:

Load *

From Data

Table2:

Join(Table1)

Load *

From Data

where Table1.request_id = Table2.request_id and

param_id = 1144 and Table1.value_id = Table2.value_id;

Some think like this

Rgds

Anand

Not applicable
Author

Hi Anand

Thanks for ur reply. But in where condition table1. field name will not work.

It is saying field name not found. any other idea ?

SunilChauhan
Champion
Champion

use

table1:

load * from

tab1

where cond if any;

inner join(table1)

load * from

tab2where cond if any;

inner join(table1)

load * from

tab1

where cond if any;

if get field not found ,

then check in ur table load weither field renamed using as Clause.

or check the name written correct .please follow case sensitive syntax

Sunil Chauhan
its_anandrjs

Hi,

Sorry make a resident table of the table after join and then use resident table use the where condition on that table

Table1:

Load *

From Data

with where condition

Join(Table1)

Load *

From Data

with where condition

load *

resident Table1

where Table1.request_id = Table2.request_id and

param_id = 1144 and Table1.value_id = Table2.value_id;

HTH

Rgds

Anand