topic Re: Calculation between fields in different tables in QlikView

Calculation between fields in different tables

Anonymous — Mon, 21 Jul 2014 13:04:40 GMT

I wan to do a calculation in the load with two fields that were brought in through different tables.

Example:

Mort_dt - Min(Place_Date)/7 as MortWeek

Mort_dt was brought in by a table named tblGAGroupMort

Place_Date was brought in by a table named tblGAGroupPlac

Any help you can offer will be greatly appreciated.

sudeepkm — Mon, 21 Jul 2014 13:15:25 GMT

if you just need the Min(Place_Date) from tblGAGroupPlac. then you can use like below.

tab1:

load * from tblGAGroupPlac;

tmp:

load Min(Place_Date) as mindt resident tab1;

let vMinDate = peek('mindt',0,'tmp');

drop table tmp;

tab2:

load *, (Mort_dt - '$(vMinDate)')/7 as MortWeek from tblGAGroupMort

veeranj — Mon, 21 Jul 2014 13:26:36 GMT

HI,

Join the two tables and then use the resident load and apply the condition on the two columns in the resident load table.

For ex:

tab1:

load a,b,c

from tab1;

join

load c,d,e from tab2;

now

load if(a>d,'above','below') as compare,a,b,c,d resident tab1;

Thanks,

Anjee