Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 Qlikuser09
		
			Qlikuser09
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		| 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.
 
					
				
		
 Lisa_P
		
			Lisa_P
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
		
			Qlikuser09
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
		
			Lisa_P
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Is that what you want ? When you sum the Value you should get what you want.
 Qlikuser09
		
			Qlikuser09
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		i want the values to be added
