Skip to main content

New to Qlik Sense

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

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
morenasm
Contributor
Contributor

Dealing with Muliple Date Fields and Dealing with multiple stock Files

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.

Data Model.PNG

Account Number Field Links most of the Columns

What is the Best way to deal with this

Thanks 

0 Replies