Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

3 Replies
Not applicable
Author

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
Author

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
Author

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