Do I need a Link Table?

[chibi]

When I select game, the date is displayed but when I select state, agency or operator no data is being displayed in the dashboard. The data does exist in the table because I have the option to choose but when I select there is no data being displayed in the KPI.  This is how the data model is

 

[Digvijay_Singh]

Not sure but it could be the data association issue, In your data model view, when you click on sold_agency_no, what do you see in the preview, Just want to check if you got matching data between fact_sales and agency table..

Also can you share your KPI measure expression just in case there is some set modifier making a difference here.

[chibi]

This is how the sold_agency_no looks like in fact_sales and agency table. The record does exist in the database but I believe its not associated properly in Qliksense. I thought if the name is the same it would automatically associate and there is a key next to it so i thought it works. But it does not. The KPI expression is also a basic one from the fact_sales table

[Digvijay_Singh]

You are right in the way that if field names are same they will get associated, we can see in the data model image that they do get associated but what I wanted to pointed out is whether they have got common values or not. The data model preview window shows subset ratio% when you click on the keyfields, that helps to identify if two tables haven't got any common values. If values are totally distinct, you woudn't get desired results when you make selections

[chibi]

You mean this? They do have common values, I double checked in the DB but they are not associated I'm not sure why 

[Digvijay_Singh]

Yes! check it in the other table as well, you should also create a straight table and add fields from both the associated table, you should see if they got proper matching values or not, all I am trying to indicate that you got proper association but underlying data might not have matching values between tables. But I m not yet sure if thats the real problem you got here.

[chibi]

Yes, they do exists in both tables 

[Digvijay_Singh · Accepted solution]

Also can you check if you got spaces in the fact table sold_agency_no, it appears its left aligned in the image you shared, but looks like its right aligned in the agency table, they look numbers to be and should be right aligned in all the tables, pl ensure if they need any cleansing..

[chibi]

Yes I did notice that too. I will need to check with the data engineer how the data was added inside. When I see the DB it seems fine (no additional space) 

[rwunderlich · Accepted solution]

It appears from the screenshots you posted that sold_agency_no is numeric (right justified) in the agency table and text (left justified) in the fact_sales table. Those differing values will not link, as shown by the 50/50 like subset ratios. 

You can fix the problem by converting the text to num when loading the fact_sales table:

num#(sold_agency_no) as sold_agency_no

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com