Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Joining Tables to new table + calculation

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.

1 Solution

Accepted Solutions
Not applicable

Re: Joining Tables to new table + calculation

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

3 Replies
Not applicable

Re: Joining Tables to new table + calculation

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;

Not applicable

Re: Joining Tables to new table + calculation

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!!

Not applicable

Re: Joining Tables to new table + calculation

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

Community Browser