Associations Not Behaving Like SQL Joins

[CaseySBS]

I am very new to Qlik Sense, so this may be a very basic answer.  Thank you all in advance.

I pull data from a live SQL Server so have made many "associations" to get all the data I need.  I'm beginner to intermediate with SQL and try to write my expressions similar to SQL.

A bit hard to explain, but here goes.

My units table is a list of all self storage rental units at all properties.  Each unit has a specific unittypeID that corresponds to a for example 10ft x 10 ft unit (100 square feet) or 10x15 (150 sq. ft).  I associate the two tables correctly via the unittypeID.   My goal is to create a simple bar chart of total square feet by property :

[Dimension = property] [Measure = an expression Sum(SqFt)]

This logic matches the SQL methodologies of SELECT property, SUM(sqft) From..., GROUP BY property.

What I expect is for the bar chart to return total square feet by property, but instead it sums each unit type (i.e. 10x10 = 100, 10x15 = 150; and returns total sq. ft = 250 sq.ft.).  It does not factor in the number of units (i.e. 10 10x10's, 20 10x15, etc.). 

What am I missing here?  I have spent hours trying to solve this on my own, so finally reaching out for help.

Thank you.

Edit: I've added screenshots of the Data Manager Visual to show associations and a screenshot of the Units - UnitTypes table association.  I've checked all associations and they are correctly linked.  

[Lech_Miszkiewicz]

I am guessing only only but it seems like your associations are not created. We would need to get a screenshot of "data model viewer" to see if association is created. Keep in mind that Qlik is case sensitive and field names and values are also case sensitive.

cheers

Lech