Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
marishnagendran
Creator
Creator

Data Modelling Challenge

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

Labels (2)
2 Replies
zwilson_borg
Contributor III
Contributor III

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
Creator
Creator
Author

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