Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Dears.
I have two tables that have a common field that join both databases, but I have a problem in a graphic, because I need that the calculation don't filter the data in the second table, I need the calculation base on the total registers, but as normally works is filtered, so the question is how can I break a relationship only to create one graphic?
Is it Possible?
BR
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Rename the field name which connect the two tables in one of the two tables:
LOAD FieldName1,
CommonFieldName
FROM Source1
LOAD FieldName2
CommonFieldName as CommonFieldName2
FROM Source2
 
					
				
		
Hi Wilmer,
Two tables join where there are similar naming conventions between them. There are different tactics one can use such to avoid the joining between two or multiple tables.
One can change field names in 3 ways As 
Use 'AS' Qualifier while loading tables 
FieldName as [Field Name] www.KarthikQlikiview.Com Mail ID: Ex: Category: Load CategoryID, CategoryName as [Category Name],
Use Alias 
Alias Qualifier Before loading the table  Alias FieldName as [Field Name]; Ex: Alias CategoryName as [Category Name]; Category: Load CategoryID, CategoryName, .......
Use Rename
Rename  We use Rename Qualifier After loading the table  Rename Field CategoryName to [Category Name]; Ex: Category: Load CategoryID, CategoryName, ....... Rename Field CategoryName to [Category Name];
Hope it helps!!!!!!!!!!!
 
					
				
		
Thanks for your help, according to my understanding with your proposed solution I break definitely the link, but I only need that the relationship be break only to make a operation in a graph.
is possible?
 
					
				
		
Thanks for your help, according to my understanding with your proposed solution I break definitely the link, but I only need that the relationship be break only to make a operation in a graph.
is possible?
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Would you be able to share a sample to look at your issue?
 
					
				
		
Did you try to use set analysis?
Something like <Fieldname>= or the P-function to override selections?
Regards
Norbert
 Chanty4u
		
			Chanty4u
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 
					
				
		
Use NOCONCATENATE OPTION BETWEEN THE TABLES
TO BREAK TWO TABLES....
 
					
				
		
I have two tables like this:
Table 1
| WO ID | Site ID | Status | Date | 
| 123 | SMU000 | Closed | 1-Apr-16 | 
| 3456 | SMU001 | Closed | 1-Apr-16 | 
| 678 | SMU003 | Closed | 3-Apr-16 | 
| 3456 | SMU000 | Closed | 5-Apr-16 | 
| 1526 | SMU002 | Cancelled | 7-Apr-16 | 
Table 2
| Site ID | Region | Project | 
| SMU000 | Coast | P1 | 
| SMU001 | East | P2 | 
| SMU002 | South | P3 | 
| SMU003 | North | P4 | 
| SMU004 | South | P2 | 
| SMU005 | Coast | P3 | 
| SMU006 | Center | P1 | 
I want to make the calculation How many work order per site, so is easy formula Count ([WO ID])/Count([Site ID])
The problem is that the two tables are join through Site ID Field, but the calculation that I want to make needs to consider WO ID from the table 1 and Site ID ONLY form the table two, but if they are join for this calculation any filter affect the final result.
