Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

marishnagendran
Contributor

Section Access_Data Modelling

Dear All,

Reduction Table Site_Master Fact_Table
     
Branch_Name Site_ID Site_ID
SA_Section Branch_Name Cust_ID
    Emp_ID
    Qty
    Value
     
Executive    
     
Emp_ID    
Branch_Name_Executive    

 

Above is my data model

I have used one reduction table based on Branch Name.

Same branch name column is referred in 2 tables (Site_Master, Executive)

In Executive table i have changed name as Branch_Name_executive to avoid synthetic key

My Reduction table works fine

But When i used Branch_Name_executive column in front-end the column shows NULL

 

I don't know why. Need your Help