Data Modelling Challenge

[marishnagendran]

Hi All,

				Fact		Branch Master
Customer_Master
				Branch_ID		Branch_ID
Customer_ID				Cust_ID		Branch_Name
Customer_Name				Product_ID		Executive_Name
				Qty
				Price
				Value
				Concatenate(Fact)		Warehouse Master
				Warehouse_ID		Warehouse_ID
				Stock_Qty		Warehouse_Name
						Warehouse_Executive Name

The above is my data model

Note : In  Branch & Warehouse Master Table : Executive Name & Warehouse_Executive_Name values are same.

My Question is

If i Select Executive Name in Branch Master, It compares with warehouse_Executive_Name and I want to fetch Stock_Qty

It is Possible???

[zwilson_borg]

In Qlik, fields are joined when they are named the same. You should just alias your [Warehouse_Executive Name] to [Executive Name] to get them to join in the associative data model, assuming they are the same fields. If you make that connection, that should bridge you [Executive Name] > [Warehouse ID] > [Stock Qty].

[marishnagendran]

Hi @zwilson_borg 

Sorry to  mention master calendar  in data model.

Already Master calendar(Date) connect with 2 fact tables. 

If I alias the Warehouse_Mame to Executive_Name then it forms synthetic key in Data Model