Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

how to summ the values from table 1 and table 2 in Qliksense(Data load editor)

Table 1        
Company Level 1 Level 2 Level 3 Value
AA Manager IT Lead IT Staff 5
AA CIO Dev Lead Dev Staff 3
AB Manager IT Lead IT Staff 2
AB CIO Dev Lead Dev Staff 1

 

Table 2        
Company Level 1 Level 2 Level 3 Value
AA Manager IT Lead IT Staff 6
AA CIO Dev Lead Dev Staff 1
AB Manager IT Lead IT Staff 1
AB CIO Dev Lead Dev Staff 5

 

I want to join both tables and sum the values column.

4 Replies
Lisa_P
Employee
Employee

If you load two tables with identical field names they will become one table and the second table will append the first, so you totals should work automatically.

Qlikuser09
Creator II
Creator II
Author

when I load two tables with similar names I'm getting something like this

Company Level 1 Level 2 Level 3 Value
AA Manager IT Lead IT Staff 5
AA CIO Dev Lead Dev Staff 3
AB Manager IT Lead IT Staff 2
AB CIO Dev Lead Dev Staff

1

 

AA Manager IT Lead IT Staff 6
AA CIO Dev Lead Dev Staff 1
AB Manager IT Lead IT Staff 1
AB CIO Dev Lead Dev Staff 5

 

Lisa_P
Employee
Employee

Is that what you want ? When you sum the Value you should get what you want.

Qlikuser09
Creator II
Creator II
Author

i want the values to be added