Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with data association.

I have problems with two fields populating in my application.  There is an association between the two tables in the file, so I’m unsure why NRT region and Metro Name aren't populating.  Both of those fields are in the Sales Data table and the expression is using the MO_BCS field from the transactions table.  Will someone advise how to correct my associations so that all fields in the pivot table populate?  Thanks. 

1 Solution

Accepted Solutions
srchilukoori
Specialist
Specialist

Hi,

You need to move the Realogy* hierachy into its own table with RealogyCoID as its key field to properly map the office ID with the office name. Check the attached app.

Thanks.

(please mark the responses as helpful or correct.)

View solution in original post

4 Replies
srchilukoori
Specialist
Specialist

Hi Regina,

You need to eliminate the synthetic keys in your application. The CID, REDistID, RealogyCoID & RealogyOffID_Rev are common in AHS & RTD tables (Qlik builds a synthetic link key using these fields to link the data in these two tables).

Img1.png

In the attached sample, I did an outer join between the AHS and RTD tables to eliminate the synthetic while retaining all the records in both tables.

Img2.png

Based on the common key formed by the above 4 fields, for the ID 630, there is no Office Name in the RTD table as the REDistIDs are different for the records. Hence, the office names are not populated in your table.

Img3.png

Thanks.

Not applicable
Author

Thanks.  This is helpful but I still have the issue that the 23 for BCS MTD is showing up with blanks for Realogy Account Name and NRT region.  I need to have the latter two fields on the same line item as the 23. 

srchilukoori
Specialist
Specialist

Hi,

You need to move the Realogy* hierachy into its own table with RealogyCoID as its key field to properly map the office ID with the office name. Check the attached app.

Thanks.

(please mark the responses as helpful or correct.)

Not applicable
Author

Thanks.