Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 gourpros
		
			gourpros
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		
Dear Qlik Experts
I have 2 input tables
| Region | Sales | 
| Asia | 100 | 
| Europe | 100 | 
| America | 100 | 
| Africa | 100 | 
| Latin | 100 | 
| Cost Header | Amount | 
| People | 40 | 
In output I want to exclude People cost from Group total like this
I don't want to load each of these entries including totals in script and then show them in a simple table without any totals as there are many measures to be calculated.
Any help on approach is highly appreciated.
| Required Output | |
| Asia | 100 | 
| Europe | 100 | 
| America | 100 | 
| Africa | 100 | 
| Latin | 100 | 
| Group Total | 500 | 
| People Cost | 40 | 
| Group Total exl People Cost | 460 | 
 Channa
		
			Channa
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		select region,sales from table1
concatenate
selct costheader ,Amount from table2
