topic new to qlikview from sql - quick help from you! in QlikView

new to qlikview from sql - quick help from you!

Tue, 15 Jul 2014 04:03:49 GMT

I am new to Qlikview, please help.

I have three tables, table A is the accounts table, table B is the org table. Table c is the required org list(one column only).

what to achieve: The accounts table A has two types in it (pry & sec) and need to join to Table B differently, i mean with two different conditions/columns, then restrict the whole final table by only the required org list(column a) in Table c.

since the join conditions for both types(pry & sec) in table A to table B are different, I thought i should create two tables from table A for each of the types and join with the different join conditions, then merge back the two tables but I keep getting only one of the join right in the final table when i check the values.

Can you please suggest the best way to do this, already done this in sql but still strguggling with it in qlikview:

Table A:

column b

column c

Table B:

column a

column b

column c

column d

Table C:

column a

For pry acct rule: table A column b = table B column b AND table A column c = table B column c

For sec acct: table A column c = table B column c

Re: new to qlikview from sql - quick help from you!

Tue, 15 Jul 2014 04:11:34 GMT

tablea:

load tableacolumnb,

tableacolumnc,

....;

left join (Tablea)

load columnb as tablecolumnb,

columnc as tablecolumc,

columnd

resident tableb

where columna = 'pry;

left join (Tablea)

oad columnb as tablecolumnb,

columnc as tablecolumc,

columnd

resident tableb

where columna = 'sec';

drop table Tableb;

rename field tablecolumnb to columnb;

rename field tablecolumnc to columnc;

Re: new to qlikview from sql - quick help from you!

Tue, 15 Jul 2014 05:40:12 GMT

Thanks Ramkumar, will try this solution out.