topic Re: How to break a relationship between tables in QlikView

How to break a relationship between tables

Mon, 11 Apr 2016 21:45:15 GMT

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?

Re: How to break a relationship between tables

sunny_talwar — Mon, 11 Apr 2016 22:12:34 GMT

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

Re: How to break a relationship between tables

Mon, 11 Apr 2016 22:14:03 GMT

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

Re: How to break a relationship between tables

Mon, 11 Apr 2016 22:30:22 GMT

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?

Re: How to break a relationship between tables

Mon, 11 Apr 2016 22:31:33 GMT

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?

Re: How to break a relationship between tables

sunny_talwar — Tue, 12 Apr 2016 02:35:53 GMT

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

Re: How to break a relationship between tables

Anonymous — Tue, 12 Apr 2016 02:54:31 GMT

Did you try to use set analysis?

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

Regards

Norbert

Re: How to break a relationship between tables

Chanty4u — Tue, 12 Apr 2016 12:10:31 GMT

chk here

P() and E() in set analysis expression

Re: How to break a relationship between tables

Tue, 12 Apr 2016 12:14:38 GMT

Use NOCONCATENATE OPTION BETWEEN THE TABLES

TO BREAK TWO TABLES....

Re: How to break a relationship between tables

Tue, 12 Apr 2016 21:22:08 GMT

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.