How to break a relationship between tables

[#1]

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]

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

[#3]

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!!!!!!!!!!!

[#4]

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?

[#5]

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]

Would you be able to share a sample to look at your issue?

[Anonymous]

Did you try to use set analysis?

Something like <Fieldname>= or the P-function to override selections?

Regards

Norbert

[Chanty4u]

chk here

P() and E() in set analysis expression

[#9]

Use NOCONCATENATE OPTION BETWEEN THE TABLES 

TO BREAK TWO TABLES....

[#10]

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.