Hi All
Im a bit new to Qlik sense Enterprise.
I need to build a Data Model for an FMCG Company.
The company does Sales with Field Reps,
I have Multiple Source's of Data with Multiple Dates an Stock items.
Heres the Flow:
Rep Has Call Cycle-->Rep Calls on Client (Call Made)-->Rep has a Target-->Rep Places Order-->Order Gets Invoice'd-->Order gets Delivered.
I have a Call Date,Order Date,Invoice Date and a delivery date. I want to build most of my reports using AutoCalendar so i Used a Comoncalender to Link Date with a Comon Calendar.(This Works)
The problem is the Stock items does not link in my tables.
Below is a view of the Data Model.
Account Number Field Links most of the Columns
What is the Best way to deal with this
Thanks