Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
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