topic Re: Joining Tables to new table + calculation in QlikView

Joining Tables to new table + calculation

Thu, 26 Jun 2014 23:25:49 GMT

Hi.

I have table_1 (excel) with fields:

YearMonth

Sum

I have table_2 (excel) with fields:

YearMonth

Total

I want to create table_3 out of those two with fields:

YearMonth

Sum

Total

Calc = Sum / Total

and drop the tables and keep with table 3.

How do i do it?

Thank You.

Thu, 26 Jun 2014 23:28:26 GMT

table_1:

load

YearMonth,

sum

from Excel.sheet1;

concatentat(table_1)

load

YearMonth,

Total

from Excel.sheet2;

table_3:

load YearMonth, Sum, Total, Sum/Total as Calc

resident table_1;

drop table table_1;

Thu, 26 Jun 2014 23:42:20 GMT

i did as you said.

i got results like this from example:

YearMonth Sum Total Sum/Total

20131 100

20131 50

it's not joined in one line....

help!!

Thu, 26 Jun 2014 23:49:21 GMT

i changed the concat to left join it worked. thank you.