How to use sql case-when with multiple variables from different tables , and store into new variable in qlikview

Thu, 03 Jan 2013 17:49:35 GMT

I am trying to create new variable "new_var" base on condition that derived from 2 variables / 2 different tables in sql .. so If I use sql I would use something like :

select id,

case when a.v1 in (1,2,3) then 'x'

when b.v2 in (1,2,3) then 'y'

end as new_var

from a

join b on a.id = b.id

I'm new to qlikview , so now I have to get two different tables to two different loads using these below

T_a:

load id , v1;

sql select id, v1

from a;

store T_a into T_a.qvd(qvd);

T_b:

load id , v2;

sql select id, v2

from b;

store T_b into T_b.qvd(qvd);

Is there a way I can create "new_var" based on variabvle v1 from table a & variable v2 from table b to get "new_var" ?

Thank you ~

topic How to use sql case-when with multiple variables from different tables , and store into new variable in qlikview in QlikView

How to use sql case-when with multiple variables from different tables , and store into new variable in qlikview